Evaluate a date and return week #
I have a date input in a worksheet and need to somehow lookup what week # the date falls in.
My weeks begin Monday and end Sunday. Screenshot of 'Date Range' worksheet below.
So if my input date in a separate worksheet is 03/15/24 I want to return 11.
I am using this in a 'LookUp' worksheet. Screenshot of 'LookUp' worksheet below;
Once I am able to return the appropriate 'Week #' I will then use the value in Index/Match formulas to return;
- 'Tech on Call'
- 'Supervisor on Call'
- 'Escalation Supervisor on Call'
The orange shaded cells are manual inputs. The white cells are Index/Match formulas.
Any help/ideas GREATLY appreciated!
Help Article Resources
Check out the Formula Handbook template!