cell reference based on date
We have a yearly schedule for all our field guys that is updated a week prior and sent out to the field so everyone knows where they will be working for the upcoming week. My question is can I tie a roll up sheet to the master schedule sheet that I would input a date on the roll up and based on that date grab the matching week portion of the master schedule so it can be sent out?
Help Article Resources
Check out the Formula Handbook template!