Using today's date to work out days outstanding since record created

[Desmondo]

Hi Guys,

I have a spreadsheet the sheet is a living document that is shared. New entries will be added daily.

I have column D = Date record created
column E = Days from today's date that record was created.

My problem is i wish to use the formula for all of column E, but not to display anything when there is no corresponding entry in column D. Currently i have applied the formula but excel is populating the columns that are not used yet with 41381. I think it might be the IF function I should be using but can't seem to get it.

Any help appreciated.

 

[TheCman81]

Something like this

=IF(D2="","",TODAY()-D2)

 

[Desmondo]

Something like this

=IF(D2="","",TODAY()-D2)

Brilliant works a treat, superfast response too.

 

[TheCman81]

No problem. Thanks for the feedback