Forum Discussion
Solved
Counting Days and Applying Charges in Excel
I am looking to create a tool where by it calculates the daily rent cost over a period of days (start date -end date) but the rent amount differs depending on the number of days. For example, 1st 7 -...
Cstranack84 Not sure how you did your math but I arrive at a total fee of £797 for 31 days. The £510 you mention would be only for the last 17 days at a rate of £30.
Have attached a revised file.
Cstranack84 Not sure how you did your math but I arrive at a total fee of £797 for 31 days. The £510 you mention would be only for the last 17 days at a rate of £30.
Have attached a revised file.
Riny_van_Eekelen , yes my math was wrong, but thank you so much this has worked perfectly really helpful appreciate it!