Referenced cells

New Contributor

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



=INDEX(August!5:5, DAY(TODAY()+5) )

@Sergei Baklan 


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.