Creating Work Weeks

Gallego · Mar 15, 2007

I have a large file with dates formatted mm/dd/yy. I want to create a
formula or macro that says "if mm/dd/yy is current week M-F,then week #."

Help!
thx.

Teethless mama · Mar 15, 2007

=IF(AND(WEEKDAY(A1,2)<6,WEEKNUM(A1)=WEEKNUM(TODAY())),WEEKNUM(TODAY()),"")

Creating Work Weeks

Gallego

Teethless mama