=EOMONTH(C4;0)+1
where C4 is your date ? format it of course as you wish

tomek

U¿ytkownik "Dianne Groom" napisa³ w wiadomo¶ci
...
A cell in an Excel workbook contains a date. I want to write macro code to
generate, in another cell, the date of the first day of the next month.



I was going to use the Excel EOMONTH function, but Excel 2002, does not
seem to support the function. I can generate the date using the DATE
function, and I tried using Application.WorksheetFunction in my macro, but
it did not work with the Excel DATE function.



Any suggestions for macro code that will generate the first day of the
next month would be appreciated.