Forum Discussion
How to get excel to display values conditional to current Month
Hello I have a personal billing excel sheet to keep track of monthly charges Some charges are every 3 months, some are every 4 months, so the monthly expectation is different each month I want ...
Alternatively, if you enter your monthly Dates with Day = 1 (i.e. 2024-01-01, 2024-02-01...) every month you can use the following option:
=SUMIF( MyTable[Date], EOMONTH( TODAY(), -1 ) +1, MyTable[Amount] )