What does this mean in English: IF today is Monday, then TODAY minus 3, ELSE
TODAY minus 1?
--
Brevity is the soul of wit.


"Gary''s Student" wrote:

=IF(WEEKDAY(TODAY())=2,TODAY()-3,TODAY()-1)

--
Gary's Student


"Wanna Learn" wrote:

Hello I have a cell formatted as =TODAY()-1 which is fine. The problem is
on Monday I want Friday's date, and of course, I get Sunday's date. How can I
correct this? thanks