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 ...
See sample attached file. I did it with a Table as I only use table. You can convert it to a Range no problem.
The Key point is your Date column must contain actual Date values i.e. 1/1/24 and not Text values like "Jan". Once you have entered your dates you can format them to display as Jan, Feb...
And next times, please don't forget to mention the version of Excel you run - Thanks