ExcelBanter - Creating Work Weeks

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Creating Work Weeks (https://www.excelbanter.com/excel-worksheet-functions/135042-creating-work-weeks.html)

Gallego

Creating Work Weeks

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

Creating Work Weeks

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

"Gallego" wrote:

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.

All times are GMT +1. The time now is 01:29 AM.