# formula for subsequent days of the week

1. ## formula for subsequent days of the week

Hi:

Is there a formula I can use so that when I type in the name of a day of the week the next cell auto inserts the next day? E.g., if I type in Monday, have the next cell(s) auto enter Tuesday, Wednesday and so on.

Thanks

2. =VLOOKUP(D2,{"Sunday","Monday";"Monday","Tuesday";"Tuesday","Wednesday";"Wednesday","Thursday";"Thursday","Friday";"Friday","Saturday";"Saturday","Sunday"},2,FALSE)

3. =IF(A1="Monday","Tuesday",IF(A1="Tuesday","Wednesday",IF(A1="Wednesday","Thursday",IF(A1="Thursday","Friday",IF(A1="Friday","Saturday",IF(A1="Saturday","Sunday",IF(A1="Sunday","Monday")))))))

4. Originally Posted by xld
=VLOOKUP(D2,{"Sunday","Monday";"Monday","Tuesday";"Tuesday","Wednesday";"Wednesday","Thursday";"Thursday","Friday";"Friday","Saturday";"Saturday","Sunday"},2,FALSE)
I tried this but after the first day I get #NA, e.g., if D2 is Sunday, then D3 comes up Monday but D4 is #NA.

Suggestion?

5. if you copy paste xld vlookup there is a gap in one of the thursdays fix that, it then worked ok for me

6. Try

=TEXT(MATCH(D2,TEXT({1,2,3,4,5,6,7},"dddd"),0)+1,"dddd")

7. Thanks - we are working now!!!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1