Date - Date = x Days formula

E

Ernest Lai

Good morning all,

I have a spreadsheet with a list of days. And i would like to create a
formula so it reads something like.

Today (read off the computer or manually typed in) - 31/01/06 = 28

Is this at all possible?
 
E

Ernest Lai

i have tried using the

=today() function but it doesnt seem to work as intended in the help file :/
 
R

Roger Govier

Hi Ernest
=TODAY()-"31/01/06"
You need to format the cell with the formula as General, then it will
show 28.
It will probably be showing 28/01/1900, as it will have picked up a date
format.
 
E

Ernest Lai

O LOL - i really need to wake up. That was perfect thanks. I actually went
and changed the format of the cell so it would get rid of the time 00:00.

thanks a lot for the replies :D
 
Top