Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,952
    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,960
    Thanks
    422
    Thanked 1,606 Times in 1,450 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,952
    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,424
    Thanks
    165
    Thanked 645 Times in 613 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,960
    Thanks
    422
    Thanked 1,606 Times in 1,450 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
  •