•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to create a formula that will provide a quarter-to-date value?
Hey all,
I need a formula that will populate the QTD column with the appropriate value. For example, I need it to show the sum of December & January, if the current month is January.
Need the QTD column to show sum of Dec & Jan, given current month is January, etc.
My current formula isn't working, and I'm having a hard time thinking of a logical formula that will accomplish this. I have a reference table with various date information. I would like this formula to work whenever I change the current month cell to the current month-end.
Any help is appreciated!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#rows.com
#Excel compatibility
#real-time data collaboration
#formula
#QTD
#current month
#sum
#December
#January
#reference table
#date selection
#current month-end
#value
#logical formula
#populate