Aug 25 2022 12:05 PM
I have a calendar of personnel with what they're doing throughout the month. I then have a schedule of where said personnel are at each day. I have the following formula on the schedule referencing the calendar:
=August!AD5 (each cell changes based off a different person ex AD5, AD6 etc).
This references the calendar and inputs the data to the schedule. I'm trying to find a way to make each cell on the schedule that references the calendar change by +1 each day. so today =August!AD5 but tomorrow would be =August!AE5. Any ideas?
Aug 25 2022 12:21 PM
Aug 26 2022 10:16 AM
I've tried messing around with the formula given but it keeps returning the dreaded #REF!
Aug 27 2022 06:29 AM
Please check attached file if it works. It was misprint in previous formula, sorry.