Forum Discussion
If date lands on a Friday, fall back to Thursday
Hi all! I'm trying to figure out what to add to my formula so that if my date falls on a Friday, it will back date it to Thursday. This is the string of formulas I have thus far: My date is...
How about this formula:
=IF(WEEKDAY(B97)=6,B97-1,B97)
(You can't actually backdate B97 itself, but you can in some nearby column easily produce the date of the Thursday immediately before it, if B97 is a Friday.)
How about this formula:
=IF(WEEKDAY(B97)=6,B97-1,B97)
(You can't actually backdate B97 itself, but you can in some nearby column easily produce the date of the Thursday immediately before it, if B97 is a Friday.)
mathetes thank you. I don’t want the date in B97 to back date, I want the resulting date from the rest of the formula chain to backdate if it falls on a Friday.
