Neall;373162 Wrote:
I have been racking my brain to figure out why my formula is not working
but
now I see that when reviewing the results through the functional
argument
tool I see that excel is reading the day (march 31 2010) as 39538.

On the spreadsheet it clearly shows me the correct date format but when
excel is reading the formula it is not.

Can someone help?

Thanks
--
NeallWhat formula are you using? you might have to use a DATE
function...supply the formula and we can help you with that.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=104449