Best rate Formula for Daily to Weekly to Monthly

ABC111

New member
Joined
Sep 15, 2021
Messages
14
Reaction score
2
Points
3
Excel Version(s)
2016
Hello To All,
Vendors charges us daily rate. End of Quarter - We do Quartey reconciliation and do best rate calculation manually.
I am trying to do best rate formula based on no of day used of that equipment- convert rate Daily to Weekly to Monthly (base on available rate)
Here I attached sample data file. I need help to update formula in column K,L,M to calculate all scenario
Thanks,
 

Attachments

  • try for best rate formula.xlsx
    9.7 KB · Views: 7
How many hours in a day?
How many days in a week (weekends, holidays)?
How many days in a month?

Don't really understand which numbers you want to input and which you want to calculate.
 
Hello Bob,
Per day-12 hrs
7 days in week
30 days in month.
In H column- I did (Weekly rate/Daily rate)-this will get me how many days it's should kick on weekly rate
In I column- I did (Monthly rate/Weekly rate)-this will give me how many weeks its' should kick on monthly rate
In J column (In some cases if weekly rate is not available)- I did (monthly rate/Daily rate)-this will give me how many days it's should kick on monthly rate.
Thanks for your help and time
 
Back
Top