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

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

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

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?

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

Try

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

Thanks - we are working now!!!