Forum Discussion
Referenced cells
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?
3 Replies
I've tried messing around with the formula given but it keeps returning the dreaded #REF!
Please check attached file if it works. It was misprint in previous formula, sorry.
