First and Last Day of the months formula

[TMan5757]

Hi everyone I need help with finding a formula that will take the 3 bottom months in chart one and have the formula put the first date of the month and the last day and put that into the correct periods in chart 3(chart 1 order goes from top to bottom current, Period 3,2,1). The formula needs to be able to change the dates if the months changes in chart 1. I hope this makes since and if it doesn't let me know what I can explain better thanks.

[#2]

@TMan5757 

Period 3 = April makes no sense to me.

See the attached version. If you change the month numbers in Chart 1, the results in Chart 3 will change automatically.

[#3]

the only reason period 3 is April because there is no data for march and i only want the the months with data

[#4]

@TMan5757 

How can we know which month corresponds to which number if it isn't simply the month number (January=1, etc.)?

[#5]

That is how I have them I Just skipped march because I only wanted the months with a QTY in chart 1

[#6 · Accepted solution]

@TMan5757 Changed the formulae in columns A and B. Added what I think you want in column J, though I'm not sure that your Excel version supports it. Perhaps you need to enter the formula in A3 and confirm it with Ctrl-Shift-Enter and copy it down.

File attached.

[#7]

Thanks for the help it all seems to work