Need a Formula for DATES

[Debbie]

Can someone help me figure out a formula for the following - I have two date
columns on my spreadsheet. I need a formula that tells me the number of
days between the two dates.
COLUMN 1 - DATE OF LAST UPDATE,
COLUMN 2 - NUMBER OF DAYS SINCE LAST UPDATE (based on the current date)

Thanks!!!

[Ron Rosenfeld]

On Tue, 8 Nov 2005 06:29:08 -0800, Debbie <Debbie@discussions.microsoft.com>
wrote:

>Can someone help me figure out a formula for the following - I have two date
>columns on my spreadsheet. I need a formula that tells me the number of
>days between the two dates.
>COLUMN 1 - DATE OF LAST UPDATE,
>COLUMN 2 - NUMBER OF DAYS SINCE LAST UPDATE (based on the current date)
>
>Thanks!!!

=TODAY() - Date_of_Last_Update

Format the result as General since excel will probably format it as a date.


--ron

[Mike]

Like
=a1-b1
format the cell to be a number with zero decimals places
Or
=today()-a1

"Debbie" wrote:

> Can someone help me figure out a formula for the following - I have two date
> columns on my spreadsheet. I need a formula that tells me the number of
> days between the two dates.
> COLUMN 1 - DATE OF LAST UPDATE,
> COLUMN 2 - NUMBER OF DAYS SINCE LAST UPDATE (based on the current date)
>
> Thanks!!!