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,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 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
    29
    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
    2,829
    Thanks
    136
    Thanked 482 Times in 459 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,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 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
  •