Excel Speadsheet problem

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Oberone007

Thread Starter
Joined
Sep 17, 2008
Messages
2
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
 

redoak

Gone but never forgotten
Joined
Jun 24, 2004
Messages
6,781
Click "Report" in the lower right an ask that your Thread be moved to the "Business Applications" Forum, if help does not come along within a day.

{redoak}
 
Joined
Sep 18, 2008
Messages
22
If you have your actual schedule in one range or sheet and mark the days in next col as 1 for working or 2 for gone fishing, you can use the following lookup statement.

1
2
3
4
5
6
7
 
Joined
Sep 18, 2008
Messages
22
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")
 
Joined
Sep 18, 2008
Messages
22
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
 
Joined
Oct 20, 2004
Messages
7,837
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"))
 

Oberone007

Thread Starter
Joined
Sep 17, 2008
Messages
2
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 ?
 
Joined
Oct 20, 2004
Messages
7,837
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top