Solved IF Function for Dates

August 25, 2020 at 09:32:41
Specs: Windows 10
In A1, I will enter a date, which can be between the first and the last day of the month. I'm trying to enter an IF formula in B1 to determine in which week does the date falls. Week is from Monday to Friday. Example:

Week 1 is from Aug 3 to 7
Week 2 is from Aug 10 to 14
Week 3 is from Aug 17 to 21
Week 4 is from Aug 24 to 28

Now for next month, week 1 will still cover Aug 31.

See More: IF Function for Dates

August 25, 2020 at 10:56:32
✔ Best Answer
See if anything here helps.

They offer various solutions based on when during the month you reset your week numbers.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Reply ↓  Report •
Related Solutions

Ask Question