I need to calculate monthly expenses but I've managed to stump myself on the formula/function. Here is my use case: I've got individual line items by user, but I want to sum their monthly expense by month. I have a range the individuals are contracted with us...say from 7/1/2022 to 5/31/23. How could I write the formula to look at that date range and pull out a specific month AND calculate the spend (if the hourly rate is known)?
Thank you in advance!
Help Article Resources
Check out the Formula Handbook template!