I think your last example should have a start date of 24th March for the desired result, and you can achieve it using this formula in E3:
=(C3-B3)*(INT(C3)>INT(B3))
and copying down.
Hope this helps.
Pete
I think your last example should have a start date of 24th March for the desired result, and you can achieve it using this formula in E3:
=(C3-B3)*(INT(C3)>INT(B3))
and copying down.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks