Thread: working out a date for a fixed day of the week
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt Sharman Matt Sharman is offline
external usenet poster
  
Posts: 2
Default working out a date for a fixed day of the week
Hi
Hope you can help.
I need a formula (is is conditional formatting?) that calculates the date
of the preceding Monday from a subsequent known date of delivery.

For example:
delivery is need for Friday 30th Nov 2007. What is the date of the preceding
Monday?
thanks Matt
Reply With QuoteReply With Quote