Whenever I copy dates from one worksheet to another, or send a
worksheet to a microsoft user, they do not open properly. The only way
around this I have found is to enter the date as a formula i.e.
=date(2005,8,1) rather than as a number formatted as a date. Any
solutions?
Before you can get a solution, you need to let us know what "do not open
properly" means...
I'm also not sure what a worksheet not opening has to do with entering
dates.
Couple of things to keep in mind:
1) XL has two date systems: 1900 and 1904. If you copy a date from one
system to another, the dates will be off by 4 years and 1 day. Switch
between the two using the Preferences/Calculation/1904 Date system
checkbox.
2) XL parses dates according to your System
Preferences/International/Formats date setting. If you try to paste in a
dd/mm/yyyy date into XL set to mm/dd/yyyy, XL's parser won't necessarily
interpret it as a date (e..g, 1/1/2005 will be interpreted the same way
by both; 1/2/05 will be 2 January in one system, 1 February in the
other; and 31/7/2005 will be interpreted as text in the mm/dd/yyyy
system.
