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

Determine year over year date for comparison
 

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

Determine year over year date for comparison
 

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

"Mike H" wrote:

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

Determine year over year date for comparison
 

Glad I could help


"zeroscou" wrote:

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

"Mike H" wrote:

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