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

=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

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

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)

"Dave F" wrote in message
...
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

=WORKDAY(TODAY(),-1)

--
HTH

Bob Phillips

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

"Wanna Learn" wrote in message
...
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

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.
"Dave F" wrote:

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

I think Dave was asking for an English explanation.

--
HTH

Bob Phillips

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

"Wanna Learn" wrote in message
...
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.
"Dave F" wrote:

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

Thanks Bob

"Bob Phillips" wrote:


=WORKDAY(TODAY(),-1)

--
HTH

Bob Phillips

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

"Wanna Learn" wrote in message
...
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