Calculate Number of days from date registered column A and Todays date Column B

[AvrilA]

Column A (that is registered date)
Column B (Derive the number of days from today's Date.
Use formula =TODAY()-A1 -It works.

Require: If Column A does not have a date entered as yet - the output in B must 0 days (this is where I am stuck)

[Phuocam]

Try this...
=IF(A1="",0,TODAY()-A1)

[AvrilA]

Thanks - it works

[Phuocam]

You're welcome.