say the month is in B1 and the full date is in A1.
range("B1").formula = "=month(A1)"

Then use autofill down.

Is this what you were looking for?
--
JNW


"ll" wrote:

Hi,
I'm working with a form that populates the spreadsheet with a year's
worth of dates. Now, I'm attempting to split the date fill according
to month.
My question is, is there a way to do this while still using the
autofill function or would I need to perhaps use a loop instead?

Thanks,
Louis