Forum Discussion

tomjohn93's avatar
tomjohn93
Copper Contributor
Oct 03, 2023
Solved

Help with an excel formula involving days of the week

Hello, The Problem I am looking at ways to save time at my job and one of the ways I came up with was using formulas in my spreadsheets instead of inputting all the data manually. The Resolution? ...
excel
Formulas and Functions
  • SanthoshKunder's avatar
    SanthoshKunder
    Oct 03, 2023

    tomjohn93 -Please check this !

     

     

    =IF(TEXT(A1,"dddd")="Sunday",A1,A1-(WEEKDAY(A1)-1))
=IF(TEXT(A1,"dddd")="Saturday",A1,A1+(7-WEEKDAY(A1)))
Patrick2788's avatar
Patrick2788
Silver Contributor
Oct 03, 2023

revised

  • tomjohn93's avatar
    tomjohn93
    Copper Contributor
    Oct 03, 2023
    Hi Patrick,
    Thanks for your response, however I tried it and it only works when the day you enter is a Sunday as it outputs back the next Sunday and Saturday,, however if, for example I entered the 11th October (Wednesday) I would want to then get back the 8th October (Sunday) and 14th October (Saturday) but Instead I get back 14th October and then the 15th October which is the next Sunday.
    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Oct 03, 2023
      I see. I don't believe you made that clear in your post but I'm glad you have a solution.
      • tomjohn93's avatar
        tomjohn93
        Copper Contributor
        Oct 03, 2023
        Sorry I should have been clearer

Resources