Thread: Subtract # of days from date, but if not sat, goto previous sat?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tom Ogilvy
 
Posts: n/a
Default Subtract # of days from date, but if not sat, goto previous sat?
something like:

=IF(WEEKDAY(TODAY()-B9,1) =
3,TODAY()-B9,TODAY()-B9-(WEEKDAY(TODAY()-B9))-(7-3))

B9 contains the number of days to subtract
Where 3 represents Tuesday. Change to suit.

--
Regards,
Tom Ogilvy


"Fernando" wrote:

Need to calculate dates by subtracting a certain number of days, but if it is
not a particular day of the week, it needs to go back to the previous week
and give me the date of that particular day of the week.
Reply With QuoteReply With Quote