The second suggestion doesn't limit it to just dates, but it might be sufficient
if you only type dates in A129.

nc wrote:

Dave

Thanks for your suggestion, but I only wanted the cell populated if there
was a date in the corresponding cell.

"Dave Peterson" wrote:

How about an alternative:

=text(a129,"mmmm")
or
=if(a129="","",text(a129,"mmmm"))





nc wrote:

Date Month

I have two columns as above Date and Month. I would like to use a macro to
write the function =MthName(MONTH(A129)) in the month column in the same row
when I populate the date field.

--

Dave Peterson


--

Dave Peterson