+ Reply to Thread
Results 1 to 7 of 7

formula for subsequent days of the week

  1. #1
    Registered User
    Join Date
    04-28-2008
    Posts
    48

    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. #2
    Forum Contributor
    Join Date
    05-21-2004
    Location
    UK
    Posts
    136
    =VLOOKUP(D2,{"Sunday","Monday";"Monday","Tuesday";"Tuesday","Wednesday";"Wednesday","Thursday";"Thursday","Friday";"Friday","Saturday";"Saturday","Sunday"},2,FALSE)

  3. #3
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    =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. #4
    Registered User
    Join Date
    04-28-2008
    Posts
    48
    Quote Originally Posted by xld View Post
    =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. #5
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    if you copy paste xld vlookup there is a gap in one of the thursdays fix that, it then worked ok for me

  6. #6
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    Try

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

  7. #7
    Registered User
    Join Date
    04-28-2008
    Posts
    48
    Thanks - we are working now!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Protected Formulas
    By georgeeasten in forum Excel General
    Replies: 13
    Last Post: 12-10-2018, 12:47 AM
  2. Formula that counts difference in days between two dates.
    By elmaco12 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-09-2008, 06:34 AM
  3. Using days of the week to compute work hours
    By ronhc213 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2008, 06:46 PM
  4. Reset Formula without Editing Formula?
    By Ogey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-27-2007, 08:44 PM
  5. How many week days in a month
    By llol_slim in forum Excel General
    Replies: 5
    Last Post: 02-08-2007, 09:01 AM

Bookmarks

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