Maybe this ?
make a cell to reference to. make that cell =TODAY() then in your column have the first cell = the referenced cell the following cells below will be the refernced cell +1
This works too, I have it running on OANDA MT4 now. Not sure if it works with all MT4 brokers though.