Comparing the same day of the week b/t two months

[Guest]

Using monthly sales data, I am looking for a way to compare mondays to
mondays b/t months. For example, first monday of November '03 to first
monday of november '04. Can anyone help?

 

[Myrna Larson]

You'll get fairly close by adding 364 days (that's 52 weeks * 7), but in some
cases that will give you the last Monday in October, so if the 1st date, Nov
3, 2003 is in A1

=A1+364+IF(MONTH(A1+364)<MONTH(A1),7,0)

 

[Ron Rosenfeld]

Using monthly sales data, I am looking for a way to compare mondays to
mondays b/t months. For example, first monday of November '03 to first
monday of november '04. Can anyone help?

Perhaps this can be simplified but with

BaseDate = any date in the initial month.

First Monday of that month:
=BaseDate-DAY(BaseDate+1)-WEEKDAY(BaseDate-DAY(BaseDate+1))+9

First Monday of the same Month in the following year:

=DATE(YEAR(BaseDate)+1,MONTH(BaseDate),1)-
DAY(DATE(YEAR(BaseDate)+1,MONTH(BaseDate),1)+1)-
WEEKDAY(DATE(YEAR(BaseDate)+1,MONTH(BaseDate),1)-
DAY(DATE(YEAR(BaseDate)+1,MONTH(BaseDate),1)+1))+9


--ron