Hello,
I have a spreadsheet that has a list of months in one column (Column A) and actuals and projections in another column (Column B) and I am calculating the YTD actuals at the end of each month. The fiscal year begins in October so I have actuals through January.
I have used the sumif formula to calculate a YTD total of the actuals by changing the names of the months to dates and then formatting as "MMMM" and using the Today() function : =SUMIF($A$6:$A$17,"<="&TODAY(),B6:B17)
Is it possible to calculate the YTD actuals without converting the names of the months to dates?
Thank you in advance for your help.
Attachment 562726
Bookmarks