You are very welcome. You can combine the cells into a single cell solution
if this is what you need. I often do this after I get the piece-wise
solution to work.
--
Gary''s Student


"David" wrote:

?B?R2FyeScncyBTdHVkZW50?= wrote

In A1 put =TODAY()
In B1 put =DATE(YEAR(A1),MONTH(A1)+1,1) date of first day of next month
In C1 put =WEEKDAY(B1) the day of B1
In D1 put =CHOOSE(C1,B1+1,B1,B1+2,B1+1,B1,B1+3,B1+2) the projected day.

Please check D1 over all cases, I didn't fully test it.

Have a good day

Thank you very much. I was hoping for a single cell solution, but I was
able to adjust cell references to put things outside my Print_Area and it
works as desired.

--
David