Adding date, but stopping at the last day of the month

[thunt1274]

I need help setting up a formula. My employer lost the contract & a new company is taking over. The current company was set up for bi-weekly pay periods, but the new company is set up for bi-monthly pay periods. In my spread sheet I have 16 cells set up for dates. I have a formula for the first cell that will put the correct date in & i know how to leave a blank space / NA. What i need help with is not to go into the next month.
For example in Feb, the last pay period will be from the 16th - 28th. I need to set up a formula that will stop on the last day of the month & show "NA" for the rest of the cells.
Any help will be greatly appreciated.

 

[pjmorris]

I'm sure someone on here can provide a formula for you, but I'm not clear on the layout of your data and the required output. If you use the XL2BB utility (button above) you can paste your spreadsheet. It helps enormously if you can show a sample of your starting point and the output you want to achieve.