Forum Discussion
Solved
First and Last Day of the months formula
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 peri...
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.
the only reason period 3 is April because there is no data for march and i only want the the months with data
How can we know which month corresponds to which number if it isn't simply the month number (January=1, etc.)?
- That is how I have them I Just skipped march because I only wanted the months with a QTY in chart 1