Tech Support Guy banner
Status
Not open for further replies.
1 - 8 of 8 Posts

· Registered
Joined
·
2 Posts
Discussion Starter · #1 ·
Hey all :)

I am looking to set something up so when I add in my scheduled days of work each week I can get my days off listed and maybe even have them say something like "Gone Fishing" ...

- my schedule is very random and usually in 2-3 week intervals
- schedule per week is sun to sat

so for instance my schedule reads like this

09/08/08 Mon
09/09/08 Tue
09/10/08 Wed
09/12/08 Fri
09/13/08 Sat
09/15/08 Mon
09/17/08 Wed
09/18/08 Thu
09/19/08 Fri
09/21/08 Sat

Would love for it to then display this ...

09/07/08 Gone Fishing
09/08/08 Mon
09/09/08 Tue
09/10/08 Wed
09/11/08 Gone Fishing
09/12/08 Fri
09/13/08 Sat
09/14/08 Gone Fishing
09/15/08 Mon
09/16/08 Gone Fishing
09/17/08 Wed
09/18/08 Thu
09/19/08 Fri
09/21/08 Sat

Is this possible ? can you point me in the right direction ?

Thanks so much

Sterling
 

· Registered
Joined
·
22 Posts
sorry mis clicked. This will do it.
A B C D Formula in col D
1 Mon19/09/20081 Mon=IF(C1=1,A1,"gone fishing")2 Tue20/09/20082 gonefishing=IF(C2=1,A2,"gone fishing")3 Wed21/09/20081 Wed=IF(C3=1,A3,"gone fishing")
 

· Registered
Joined
·
22 Posts
Bad format day, sorry

Col 1 = date, col 2 = day, col 3 = 1 for working or 2 for gone fishing

Formula =IF(C3=1,A3,"gone fishing") will return either the weekday name or the text "gone fishing"

Regards
 

· Registered
Joined
·
7,842 Posts
Oberone, the problem with what you are requesting is that you want a response in the column that would hold a formula that would also look to that column for information.
However, if you have in column A (starting in my case in A1) the list of dates that you are to work, and in column B (again, starting in B1) the list of all dates, then enter the following formula in C1 and drag down
=IF(ISNA(TEXT(VLOOKUP(B1,A:A,1,0),"mm/dd/yy")),"Gone Fishing",TEXT(B1,"mm/dd/yy"))
 

· Registered
Joined
·
2 Posts
Discussion Starter · #7 ·
Ok ... thanks for the good ideas ... even if I try and use say a static sheet for days of month ... then dump in my shed can I get it to display that way ya think ... like blank for working and gone fishing for the days I have off

Sept Gone Fishing

1
2
3
4 Gone Fishing
5
6
7
8
9 Gone Fishing
10
11
12
13
etc

any ideas ?
 

· Registered
Joined
·
7,842 Posts
Well, from my previous post, you can use the same idea but alter the formula to
=IF(ISNA(TEXT(VLOOKUP(B1,A:A,1,0),"mm/dd/yy")),"Gone Fishing","")
That way, if the date isn't found in your list of work dates, it displays "Gone FIshing" (without the "") and if it is it displays "" - which is blank.
 
1 - 8 of 8 Posts
Status
Not open for further replies.
Top