Did you put a valid year number in cell B1?

--
HTH,
Bernie
MS Excel MVP


"ChrisMattock" wrote in message
news:ChrisMattock.2aiyyq_1152191415.9068@excelforu m-nospam.com...

Well it adjusts for the Month, i.e. February had 28 days in it, but each
day is being displayed with an error, the top date being #VALUE! any
suggestions?


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=558817