Hi,
I'm trying to forecast weekly cost of equipment and rounding up the weekly costfor a full 7 day period so if a hire commences on a Thursday or a FridayI'd like to round up to the Monday howver I cannot seem to get the formula towork:
B3 = Hire From Date of 31 July 2018
C3 = Anticipated Hire End Date of 14 Aug 2018
G3 = Weekly Hire Cost of £1000
Column V = Week Ending 05 Aug 2018
Column W Week Ending 12 Aug 2018
Cell W3 = =IF(AND(V$1>=$B3, $G3,W$1<=$C3),$G3,"")
https://1drv.ms/x/s!As-9OWf6QipWg1CXEyAReRvMx65r
However, V3 for week ending 5 Aug 2018 is blank I should have a total of£2000 costs for these 2 weeks, I only have £1000. Can anyone help with theformula?
Thanks
I'm trying to forecast weekly cost of equipment and rounding up the weekly costfor a full 7 day period so if a hire commences on a Thursday or a FridayI'd like to round up to the Monday howver I cannot seem to get the formula towork:
B3 = Hire From Date of 31 July 2018
C3 = Anticipated Hire End Date of 14 Aug 2018
G3 = Weekly Hire Cost of £1000
Column V = Week Ending 05 Aug 2018
Column W Week Ending 12 Aug 2018
Cell W3 = =IF(AND(V$1>=$B3, $G3,W$1<=$C3),$G3,"")
https://1drv.ms/x/s!As-9OWf6QipWg1CXEyAReRvMx65r
However, V3 for week ending 5 Aug 2018 is blank I should have a total of£2000 costs for these 2 weeks, I only have £1000. Can anyone help with theformula?
Thanks
