Hey,
I am building a spreadsheet to track different dates along our sales process. Unfortunately I am stumped on a formula so any help would be great!
The problem I am having is the "Value if True" statement, everything is below-
=IF(G2>BB1, =G2-BB1, "Past Due")
Logical Test
G2 > BB1 (Greater)
G2-Date of item within contract
BB1-This is "=Today()" so it resets to today's date
Value if True
I would like to have the difference of days between "Todays Date" and the Date from the contract
Example: if it is May 17 today, and my item is due May 18, it would display 1 day
Value if False
If G2 is greater than Todays Date, I would like it to read "Past Due"
Any thoughts on this?
Thanks
Bookmarks