I'm stuck with working the TODAY feature into a formula.
In column G I want to use TODAY to compare to the date in column E. If the difference between TODAY and the date in column E is less than three months, I want the formula to spit out "pending" in column G. If it's more than 3, "delayed."
I was using an index formula to compare the date in column E to the first date listed in column A but it's just not accurate enough. I'm unfamiliar with TODAY except to use it as =TODAY() to spit out the date in a cell.
Is this formula possible?
Bookmarks