Months in the quarter

[jswillcox]

I am working on a comission tracker. One thing I would like is for three different boxes to show the three months in a quarter. So when I share my tracker it will not have to be manually input.

G7 = Jan
G8 = Feb
G9 = Mar

Until this quarter ends. Then it updates these boxes to the next quarters months.

G7 = Apr
G8 = May
G9 = June

ect.

I appreciate any help you can provie!

 

[Rick Rothstein]

One way - put this formula in cell G7 and copy it down to cell G9...

=TEXT(28*ROWS($1:1)*(1+3*INT((MONTH(TODAY())-1)/3)),"mmmm")

 

[JoeMo]

Another way - format G7:G9 as "MMM".

Excel Workbook
	G
7	Jan
8	Feb
9	Mar
Sheet5

 

[Rick Rothstein]

Another way - format G7:G9 as "MMM".

If the OP chooses to use your suggestion of formatting the cells to produce month name, then this simple formula can be used in cell G7 (cells G8 and G9 would remain the same as you posted)...

=28+84*INT((MONTH(TODAY())-1)/3)

I would note that the dates that end up in cells G7:G9 with my method would not be usable for their date values, only for their month names (such as would appear in header cells or a text string output).

 

[Rick Rothstein]

If the OP chooses to use your suggestion of formatting the cells to produce month name, then this simple formula can be used in cell G7 (cells G8 and G9 would remain the same as you posted)...

=28+84*INT((MONTH(TODAY())-1)/3)

I would note that the dates that end up in cells G7:G9 with my method would not be usable for their date values, only for their month names (such as would appear in header cells or a text string output).

I guess if it needed to be date relevant, you could use this formula...

=DATE(YEAR(NOW()),1,28+84*INT((MONTH(NOW())-1)/3))

but now my formula is only one function call less than yours, so I am not sure if that is a significant enough difference to warrant choosing my functions over yours.