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!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!