Formula/Script to change reference cell based on date?

Originally Posted by watersev

hi rbtroj, welcome to the forum, is that what you are looking for?

=INDEX(Sheet1!$A$1:$A$31,DAY(NOW()),1)

- formula for Sheet2 cell A1

Thanks, watersev! That seems to do the trick!