=MONTH(A1)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"R.Culley" wrote in message
...
Many thanks - I want to set up an accounting worksheet with a monthly
payment, any help very gratefully received.