Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Need Formula to read 2017 dated

    Hi

    Can some one tell me how to edit this formula to work for 2017 it currently works for current year

    =IF(D2="","",CHOOSE(WEEKDAY(F5),"Sunday","Monday", "Tuesday","Wednesday","Thursday","Friday","Saturda y"))


    Many Thanks in advance

    Braddy60
    If you are a fool at forty, you will always be a fool

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,774
    Thanks
    402
    Thanked 1,550 Times in 1,405 Posts
    Braddy,

    What makes you think it doesn't work for 2017. It sure seems to work just fine on Excel 2010.

    ExcelWeekday.PNG

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post
    Hi RetiredGeek

    Yeah I had a senior moment I forgot the change the F5 location

    Many Thanks for your reply

    Braddy60
    If you are a fool at forty, you will always be a fool

  4. #4
    Lounger
    Join Date
    May 2003
    Posts
    33
    Thanks
    3
    Thanked 1 Time in 1 Post
    seems a rather long formula though
    =IF(D2="","",text(F5,"DDDD"))
    is a lot shorter, and would do the same thing

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    3,188
    Thanks
    152
    Thanked 591 Times in 561 Posts
    Hi aidan

    ..I like your formula!
    (but the two formulas will give different results if there is an error e.g. if you put any text or negatve number in F5)

    zeddy

  6. #6
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,774
    Thanks
    402
    Thanked 1,550 Times in 1,405 Posts
    Hey Y'all,

    To demonstrate Zeddy's fine point I added an IFError to each of the formulas

    =IFERROR(IF(D2="","",CHOOSE(WEEKDAY(F5),"Sunday"," Monday", "Tuesday","Wednesday","Thursday","Friday","Saturda y")),"")

    =IFERROR(IF(D2="","",TEXT(F5,"DDDD")),"")


    resulting in:

    weekdaytest.PNG

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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