bullhead14
New Member
- Joined
- Jul 29, 2013
- Messages
- 2
Can't see the wood for the trees on this......
I am trying to calculate the hire period for standing pieces of kit.
Col A is Erect Date
Col B is Dismantle Date
Col C is Off Hire date
Col D is calculating the number of hire days =IF(A2="",0,IF(C2="",DATE-A2,C2-A2)) this works when I have dates allocated within Col A and C but when Col A date is inserted and is yet to be dismantled it returns a negative in number form.
Any guidance would be greatly appreciated.
I am trying to calculate the hire period for standing pieces of kit.
Col A is Erect Date
Col B is Dismantle Date
Col C is Off Hire date
Col D is calculating the number of hire days =IF(A2="",0,IF(C2="",DATE-A2,C2-A2)) this works when I have dates allocated within Col A and C but when Col A date is inserted and is yet to be dismantled it returns a negative in number form.
Any guidance would be greatly appreciated.