Hi,

I am receiving dates in an excel file that appear to be in format m-dd-
yyyy format. When I execute the formulas day() and month() they get
them the wrong way round ie the month returns the day and vice versa.

Can someone tell me how I get around this problem and why its
occuring?

regards
Colm.