Only bill for week days during billing cycle (i.e. M-F).
More than 3 days = 1 week's rental
More than 3 weeks = 1 Month's Rental
Currently "Days" in column E are calculated using Networkdays function.
Based on entering two dates (Rent start, Rent finished), I need to calculate the number of Months, Weeks, and Days then run a formula to calculate the total value to invoice.
The highlighted cells under columns J,K,L on row 18 are my initial attempts at this calculation. Please Help!!
I've attached the excel sheet.
Bookmarks