Hi everyone.
I need to calculate the total cost given the number of (week) days the equipment was rented.
This is the info:
Start date (A2)
End date (B2)
Total days (B3) (=networkdays(A2,B2))
Rates
Daily (1-3 days) at $75
Weekly (4-5 days always equal to 5) at $375
Monthly (= 22 days) at $1,400
After some help from Google, I found the formula below works to give me the total $.
=$D$1*MOD($B$3,7)*(MOD($B$3,7) < 5)+$D$2*((MOD($B$3,7) > 4)+INT(MOD($B$3,22)/7))+$D$3*INT($B$3/22)
(the formula above has spaces between the > and <, otherwise, it won' post)
However, I still need to know the breakdown of how many months, weeks, and days B3 equals to. Anyone has any ideas how I can get this breakdown?
? Months
? Weeks
? Days
Total = B3
Thank you!
Bookmarks