date and workday function

For the date, assume that - although payments are due the end of each month - they are actually made on the first workday of each month (disregarding federal holidays).

so if i use the today() on a cell and then using that today, i want to generate the the payment day on this first of the next month. so for example, today is 9/13/2015, i want to generate the payment date on 10/1/2015 and then on the first for every month after october; 11, 12, 1, etc.

is there a way to do this without using the eomonth function?

needs to be the 1st workday of the month, the 1st of the month is not necessary the work date

i found this function / formula on the net = =WORKDAY(J9-DAY(J9),1) this works perfectly but does anyone know how to drag this formula down to any number of cells? say i want to know the 1st working date of the next 5 months.

Originally Posted by FDibbins

Did you try my suggestion?

yes it did work but my class did not cover that stuff, only things that have been covered so far is date and workdate functions.

Originally Posted by bebo021999

Maybe:

=WORKDAY(A1+32-DAY(A1+32),1)

that works except for some reason jan 1 shows up has a working day.

but i really want to thank you, this is maybe as close as i will ever get

Yes it is an assignment. The professor will release the solutions later I will post it up.