Need a Formula for DATES

[Guest]

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]

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

 

[Guest]

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