The last part of the formula dosen't work when I replace 'date' with
'datavalue'. There has got to be a way to code the formula to simple take the
'2005,1,1' from the H2 field and insert it into the formula. Any other ideas?


"gearoi" wrote:


does 'datevalue (h2)' help?

It gets rid of the need to split up months and stuff.

Differences between datevalues give you the number of days.


--
gearoi
------------------------------------------------------------------------
gearoi's Profile: http://www.excelforum.com/member.php...o&userid=26576
View this thread: http://www.excelforum.com/showthread...hreadid=401924