Formula. A1=January, B1=2012. How to get C1=first date of month, D1= last date of...

Hi
Does anyone know a formula that would do the following:

Lets say A1=January and B1=2012. How can I have formula in C1 and D1 so C1 would return first date of month (i.e. 01/01/2012) and D1 would return last date of the month (e.i. 31/01/2012.


The dates would have to be in UK format i.e. dd/mm/yyyy


Any help is greatly appreciated.

Thanks shg
=--(A1&B1) gives me the first date of the month. Much appreeciated.
But now how to do the other one, how to populate in cell D1 the last date of the month i.e 31/01/2012


Any ideas?

Thanks for the quick reply.
=eomonth(c1, 0) leads up to error: #NAME?

I'm using Excel 2003. By the looks of it 2003 does not support eomonth (http://www.pcreview.co.uk/forums/mis...-t1756997.html

I can not install anything on work computers (system admins are pit overprotective with everything, I have gone down that route before with lo luck). There will be other users using this spreadsheet who are also on 2003.

Any idea how to achieve the same without eomonth???
Your help would be much appreciated. I could just use the start of date and chuck +30 days on it but I would rather get it dead on the money.

Cheers