count day with isblank formula

[Mattlake]

Hi

this is so dumb but google cannot help.

I need to count the days between a date and to, but to be blank if the date is blank

I have put =ABS(IF(ISBLANK(D5),"",TODAY()-D5)) which works apart from leaving blank if D5 is empty it show #value.

If this is possible please help, if not please say

Thank you for your help and advice

 

[Fluff]

How about

=if(d5="","",abs(today()-d5))

 

[Mattlake]

it is soo simple when someone shows the way to do it.

 

[Fluff]

Glad to help & thanks for the feedback.

 

[Mattlake]

is there a way to make it positive if the date is in the future and negative in the past?

 

[Fluff]

How about

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

 

[Mattlake]

thank you so much for making me look as dumb as i feel now

why is so simple when someone else does it I was making even that part more complicated than it needed be

 

[Fluff]

Glad to help & thanks for the feedback.