Today()-1

W

Wanna Learn

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
 
D

Dave F

What does this mean in English: IF today is Monday, then TODAY minus 3, ELSE
TODAY minus 1?
 
B

Bob Phillips

Get the previous WORKING day.

If today is a Monday, subtract 3 days from it so as to avoid Saturday and
Sunday, otherwise just subtract 1 day.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
B

Bob Phillips

=WORKDAY(TODAY(),-1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
W

Wanna Learn

Gary Thank you
and Dave F
an extra thanks for the "English" explanation. Since the only way to learn
is to understand what is being said.
 
B

Bob Phillips

I think Dave was asking for an English explanation.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top