Hi Rosa
A date -once recognized as a date- is a date is a date is a date. Whether day, month or
year comes first is a question of cell formatting and/or regional setings in Windows,
those are just different ways of displaying the very same date. The inner workings of
Microsoft dates/time is "days since new year to 1900", and it may well be displayed as a
decimal number 37 thousand some, or maybe even "monday 5". Still a valid date.
So on the proper american system a date will convert itself. Or if you change your
regional settings it will do the same.
How do you know if it's a date and not a text looking like a date ? The formula bar will
probably display the same date slightly differently than what you see in the cell, and you
can alter the cell display with Format > Cells > Dates without changing the formula bar
value.
