software

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?

i have tried using the

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

quot;Ernest Laiquot; wrote:

gt; Good morning all,
gt;
gt; I have a spreadsheet with a list of days. And i would like to create a
gt; formula so it reads something like.
gt;
gt; Today (read off the computer or manually typed in) - 31/01/06 = 28
gt;
gt; Is this at all possible?

Put your date in A1 and =today() in B1 and =DATEDIF(A1,B1,quot;dquot;) in C1
--
Gary's Studentquot;Ernest Laiquot; wrote:

gt; Good morning all,
gt;
gt; I have a spreadsheet with a list of days. And i would like to create a
gt; formula so it reads something like.
gt;
gt; Today (read off the computer or manually typed in) - 31/01/06 = 28
gt;
gt; Is this at all possible?

Hi Ernest
=TODAY()-quot;31/01/06quot;
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.

--
Regards

Roger Govierquot;Ernest Laiquot; gt; wrote in message
...
gt;i have tried using the
gt;
gt; =today() function but it doesnt seem to work as intended in the help
gt; file :/
gt;
gt; quot;Ernest Laiquot; wrote:
gt;
gt;gt; Good morning all,
gt;gt;
gt;gt; I have a spreadsheet with a list of days. And i would like to create
gt;gt; a
gt;gt; formula so it reads something like.
gt;gt;
gt;gt; Today (read off the computer or manually typed in) - 31/01/06 = 28
gt;gt;
gt;gt; Is this at all possible?
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

quot;Roger Govierquot; wrote:

gt; Hi Ernest
gt; =TODAY()-quot;31/01/06quot;
gt; You need to format the cell with the formula as General, then it will
gt; show 28.
gt; It will probably be showing 28/01/1900, as it will have picked up a date
gt; format.
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Ernest Laiquot; gt; wrote in message
gt; ...
gt; gt;i have tried using the
gt; gt;
gt; gt; =today() function but it doesnt seem to work as intended in the help
gt; gt; file :/
gt; gt;
gt; gt; quot;Ernest Laiquot; wrote:
gt; gt;
gt; gt;gt; Good morning all,
gt; gt;gt;
gt; gt;gt; I have a spreadsheet with a list of days. And i would like to create
gt; gt;gt; a
gt; gt;gt; formula so it reads something like.
gt; gt;gt;
gt; gt;gt; Today (read off the computer or manually typed in) - 31/01/06 = 28
gt; gt;gt;
gt; gt;gt; Is this at all possible?
gt;
gt;
gt;