excel_2009
Active Member
- Joined
- Sep 14, 2009
- Messages
- 318
hi excel gurus,
I was just wondering if someone could help me, i've the following formula that doesn't work:
It generates a #NUM! error when the date it's referring to is in the future
I hope someone can help me?
Thank you!!!!
I was just wondering if someone could help me, i've the following formula that doesn't work:
Code:
=IF((DATEDIF(E36,TODAY(),"D"))<0,"On time")
It generates a #NUM! error when the date it's referring to is in the future
I hope someone can help me?
Thank you!!!!