Negative #'s using DATEDIF

[jessicamessina]

I'm using the following formula which works great until it needs to return a negative number:

=DATEDIF(G13,D13,"D))

D = exp date
G = date quote sent
if date quote sent is after exp date, it doesn't return a number.

Is there an easy way to resolve?
Thanks!
Jess

 

[sheetspread]

Use max/min

 

[barry houdini]

Rather than DATEDIF just subtract, i.e.

=D13-G13

format result cell as number with zero decimal places

That way you will get a positive number if exp date if after date quote sent.....but a negative number if it's the other way round
​