Hi,

Dates in Excel are numbers - format one as general to see that - and we only
see them as dates because of the applied formatting.

The problem your experiencing arises because in a formula that format can be
lost and has the be added back by formatting the formula cell as a date or
using the TEXT function.

If you post the problematic formula then someone will help you sort it out.

Mike

"Neall" 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
--
Neall