# 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
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
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}

#### Nic Cunliffe

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

#### Nic Cunliffe

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")

#### Nic Cunliffe

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

#### slurpee55

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
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 ?

#### slurpee55

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.

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.

over 807,865 other people just like you!