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
Bookmarks