Creating Work Weeks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=IF(AND(WEEKDAY(A1,2)<6,WEEKNUM(A1)=WEEKNUM(TODAY())),WEEKNUM(TODAY()),"")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change date format in Excel footer 2
Date Format 2
date and time difference 19
How do I calculate age using a 12 digit social security number in MS Excel? 0
Criteria For SU<IF 5
can I change the date format as dd-mm-yy 7
date computing and sum issues 6
CountA and ArrayFormula 4

Back
Top