View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zeroscou zeroscou is offline
external usenet poster
 
Posts: 2
Default Determine year over year date for comparison

Hello, I am trying to determine the date of the same Monday last year based
on the date of the latest Monday's date.

If I just subtract 364 from the current date, I can get the date; however, I
think that this formula would create errors if there is a leap year.

Thank you,
Brian