Determine year over year date for comparison

[zeroscou]

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

 

[Mike H]

Hi,

Try this

=IF(WEEKDAY(A1-364)=2,A1-364,A1-365)

Mike

 

[zeroscou]

Thank you Mike, that works and is nice and simple.

 

[Mike H]

Glad I could help

Thank you Mike, that works and is nice and simple.