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

R

rondo

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?
 
M

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)
 
R

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?
Click to expand...

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
 
Top