Hello everyone,

I have a simple tracking sheet that we have people entering overtime
usage in to. I am trying to summarize this info with a basic
pivotchart and group it by month, day, trade, etc.

Anyway, there is a column for inputing the date in to. These dates
have been entered as D/M/YYYY. The trouble is, Excel reads this as M/D/
YYYY, so where 11/4/2008 is intended to be interpreted as the 11th of
April, Excel is reading it as November the 4th.

This results in an error whenever the "Day" exceeds 12, and so I can
not group the results.

Questions:
1) Is there a way to force excel to interpret a text input date in the
format I desire? Such as, "read 11/4/2008 as D/M/YYYY"?
2) If no to the above, I can probably parse the text to create the
decimal value Excel uses for dates (where the 5th of May 2008 = 39573
for example), except I do not know how to arrive at 39573 from
5/5/2008. Any help here would also be appreciated.

I'll keep working. Thanks in advance!