Hi Roger,
Thanks for your help but unfortunately i doesn't work or i can't get it
to work.
In A1 i typed:
=DATE(YEAR(NOW()),MONTH(NOW()),ROW(1:1))
Which was fine and brought up the start of the month.
then when i went to A2 and typed:
=A1 + 1
It came up:
#VALUE!
When i hover the mouse over it, it says: "A value used in the formula
is of the wrong data type."
The same message occurs even when i change A1 to =Today().
Thanks again.
--
Jim9980
------------------------------------------------------------------------
Jim9980's Profile:
http://www.excelforum.com/member.php...o&userid=30583
View this thread:
http://www.excelforum.com/showthread...hreadid=502303