Hi Everyone just having trouble calculating negative days between days if anyone could help!
Thankyou!
please see attachment
Thanks!
Hi Everyone just having trouble calculating negative days between days if anyone could help!
Thankyou!
please see attachment
Thanks!
Please try at D5 drag down
=C5-$B$1
Try this formula in D5 and copy down:
=C5-$B$1
Thankyou Bo and Phuocam! worked perfectly!
I assume that =DATEDIF cant produce negative days?, ive been looking around internet for answers but haven't found anything so far.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks