View Single Post
 
Old 05-06-2020, 01:31 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Easiest way is to use a helper column. Attached is an example with different possible solutions:

You can define dynamic named range (dnDateMonth in my example), and use this to calculate the helper column DateMonth;
Or you can calculate month number directly in helper column - like in alternate helper column DateMonth2 - instead;
You can calculate current month like in named cell nCurrMonth, and use nCurrMonth in formula to calculate the amount for current month;
You can select the month using Data Validation List for cell nMonth, and use nMonth in formula to calculate the amount for selected month. You need a helper sheet (which can be hidden) to create a list of available months which is based on your date amount entries.
Attached Files
File Type: xlsx CurrentMonthSpending.xlsx (13.9 KB, 6 views)
Reply With Quote