Hi All
I'm having a bit of a problem with a formula calculating if a date is greater than =today()+2 then it should return as within the agreed time but if it's below that time it is about to breach it's agreed times
Could it have anything to do with the date/time format setting of the =today() function?
For some reason the formula shows everything as either within the agreed time or breached it's agreed time
I've attached the example to show you what I mean and highlighted the fields that should show the information
Any advise will be much appreciate
Thanks in Advance
Dan
Bookmarks