Subtract 2 days and if it falls on Sat or Sun display Friday.
On Mon, 31 Mar 2008 22:20:01 -0700, Teethless mama
wrote:
=WORKDAY(A1,-3)
I don't believe that is what th OP asked.
Yours gives for Tuesday 4/1/2008 -- Thursday 3/27/2008
But 4/1/2008 less three days is Saturday 3/29/2008, so, by his request, you
should only fall bact to Friday, not Thursday.
"ScottG" wrote:
Date substraction - A1 has 4/2/2008 and I want to subtract three days.
Therefore, the answer is 3/30/2008 (Sunday) then I want to fall back to
Friday 3/28/2008.
=WORKDAY(A1-2,-1)
--ron
|