jessicamessina
New Member
- Joined
- Dec 8, 2017
- Messages
- 3
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
=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