On Monday, May 21, 2012 6:57:35 AM UTC-4, colmkav wrote:
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.

More information is needed. Pick a specific date. Re-format the cell to integer. What is the date as it appears and what is the integer value.