Need a Formula for DATES

D

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!!!
 
R

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!!!
Click to expand...

=TODAY() - Date_of_Last_Update

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


--ron
 
M

Mike

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