Date - Date = x Days formula

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 :/

"Ernest Lai" wrote:

> 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?

Put your date in A1 and =today() in B1 and =DATEDIF(A1,B1,"d") in C1
--
Gary's Student


"Ernest Lai" wrote:

> 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?

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.

--
Regards

Roger Govier


"Ernest Lai" <ErnestLai@discussions.microsoft.com> wrote in message
news:C85A043C-1145-4470-A532-BA00C9429C75@microsoft.com...
>i have tried using the
>
> =today() function but it doesnt seem to work as intended in the help
> file :/
>
> "Ernest Lai" wrote:
>
>> 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?

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

"Roger Govier" wrote:

> 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.
>
> --
> Regards
>
> Roger Govier
>
>
> "Ernest Lai" <ErnestLai@discussions.microsoft.com> wrote in message
> news:C85A043C-1145-4470-A532-BA00C9429C75@microsoft.com...
> >i have tried using the
> >
> > =today() function but it doesnt seem to work as intended in the help
> > file :/
> >
> > "Ernest Lai" wrote:
> >
> >> 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?
>
>
>