Forum Discussion
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? ...
tomjohn93 -Please check this !
=IF(TEXT(A1,"dddd")="Sunday",A1,A1-(WEEKDAY(A1)-1)) =IF(TEXT(A1,"dddd")="Saturday",A1,A1+(7-WEEKDAY(A1)))
tomjohn93 -Please check this !
=IF(TEXT(A1,"dddd")="Sunday",A1,A1-(WEEKDAY(A1)-1))
=IF(TEXT(A1,"dddd")="Saturday",A1,A1+(7-WEEKDAY(A1)))
SanthoshKunder
Thank you that works great, thanks for your help
Thank you that works great, thanks for your help