Find Today's Month, and add x

[MikeR320]

I have been bogged down with this for a couple hours now, so I apologize in advanced if this is poorly written - any help is greatly appreciated.

Fiscal Year Calendar Ranging from AH:CO as follows
Row 9 (Years from 2015 to 2019)
Row 10 (Months from 1-12)
Row 11 (Number of Widgets, found via if(sumif(blahblah)>0,sumif(blahblah),blah*(1+x))

I am trying to dynamically reference today's date, and IF a certain scenario (a, b, c) is selected in AH2, add x (e.g. 5, 10, 15) number of widgets to each month beginning next month and moving forward until the end of the range in CO11.

Thanks in advanced, you geniuses you.

 

[RickXL]

Hi,

Strategy: Convert all dates to Excel dateserial numbers then use the built-in date functions to help you.

I think you will need to add data to the months where this is true:
DATE(F9,F10,1)>EOMONTH(TODAY(),0)

For example:
=IF(DATE(F9,F10,1)>EOMONTH(TODAY(),0), add to this month, don't add to this one)

DATE() is used to convert your year and month rows into an Excel date for the first of the month.
EOMONTH is used to find the last day of the current month.