System Date

[Joe]

Hi,

how to use the system Date to calculate the number of
days lag after the initial date has key in one of the
cell and the end date has forgotten to type in?

example:

Date Descritption End Date Number of days
02/10/04 Test

thanks
regards,
Joe

 

[Frank Kabel]

Hi
use the function
TODAY()
for this

 

[Myrna Larson]

Assuming you are using columns A

=IF(ISBLANK(C2),TODAY(),C2)-A2