How will excel know which month you want? Is it the current month and year?

How many cells are involved?

You could get "auto finish" to kick in, but it would require a macro attached to the cell so that when you type the day, the month and year will appear.

Regards,

David