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.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
