Jul 06 2021 09:04 AM
Good day all :)
I have tried so many variations and I just can't get it to work....I'm sure I'm overthinking it...LOL
I have a spreadsheet I created to track our service calls and when they were completed, billed and paid by our clients.
The first one I'm struggling with is to get rid of the #num error it is returning when I try to calculate the days between when the call was completed vs when we billed it out. Ideally, it would return a "0". I have tried:
=iferror(dateif(ae3,ai3,"d"),0)
it returns 0 for all!! Not right!
the current formula entered (giving me the #num error you see in my screen shot) is:
=DATEDIF('Service Tracker '!$AE3,'Service Tracker '!$AI3,"d")
Once I get this one fixed....then the next issue :)
thanks muchly for all your help!
Jul 06 2021 09:16 AM
SolutionJul 06 2021 09:25 AM
Jul 06 2021 09:27 AM
Jul 06 2021 09:16 AM
SolutionOne way:
=IF(AND(ISNUMBER(AE3),ISNUMBER(AI3)), AI3-AE3, "")