It is simple enough to have a cell reference another cell with a formula like so =A1

What if a cell reference is dependent on a date? For example, during the first 30 days in 2004, the
cell reference is =A1 and the next x number of days the reference will be =A2.