Hi,

I am trying to create a date value formula to refence the date in another cell, minus todays date, to give a 'days to go' value.

Currently I have only been sucessful using the following formula:

=DATEVALUE("28/06/2013")-TODAY()


I would like to remove the 28/06/2013 from the formula and have it reference the date from another cell.

For example, if I change the formula to:

=DATEVALUE("A7")-TODAY()

This brings up an error. I have the date in cell A7 as 28/06/2013 and formatted to date, but this date may need to be changed, and I want to avoid having to update the cell A7, and the DATEVALUE formula in the next cell.

Thanks