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.