Check out Chip's site Laphan
http://www.cpearson.com/excel/datetime.htm#DaysInMonth

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Laphan" wrote in message ...
Hi All

Can anybody give me pointers on how I can get 1 specific cell to
auto-display the start of the current month, Laphan 1-11-03 and another cell
to show the end, eg 30-11-03. I also want these cells to be editable so
that the user can change the date if they want to something like 20-12-03.

Any ideas??

Rgds


Lagan