day increasing by 1 when i drag and drop
Are you sure it's not increasing by 1 day + 4 years?
That behavior happens when you copy from a workbook using the 1900 date
system and paste into a workbook using the 1904 date system.
If it's really only one day, I've no idea...
In article ,
dencara wrote:
when I drag and drop a date format the day value increases by one. how do I
stop this? Thank you
|