hi, Please help me solve my problem about error on negative results on two dates,(#num!).
e.g start date (D2) is greater than end date(O2)
I am using this codes
=IF(D2>O2,"-"&ABS(D2-O2),DATEDIF(D2,O2,"m"))
Thanks
hi, Please help me solve my problem about error on negative results on two dates,(#num!).
e.g start date (D2) is greater than end date(O2)
I am using this codes
=IF(D2>O2,"-"&ABS(D2-O2),DATEDIF(D2,O2,"m"))
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks