If the function is in A1 then use this in B1
=DATE(YEAR(A1),MONTH(A1)+1,1)

or you can replace A1 with the formula you have returning a date between 2nd
and last day of the month...
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"JR" wrote:

If a cell returns a date between the 2nd and last day of a given month. What
worksheet function can be used to return the 1st day of the following month?
--
JR