Hi,

Try this

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

Mike

"zeroscou" wrote:

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