View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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