C
colmkav
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.
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.