day increasing by 1 when i drag and drop

D

dencara

when I drag and drop a date format the day value increases by one. how do I
stop this? Thank you
 
M

Mike H

Hi,

With a date in A1 put this in a2
=A1
now drag A2 and the date wont change.

Mike
 
J

JE McGimpsey

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...
 
P

Peo Sjoblom

What do you mean by drag and drop, if you mean you are dragging a date using
the mouse
and autofill? If you don't want it to increase by a day hold down ctrl while
copying.


--


Regards,


Peo Sjoblom
 
G

Gord Dibben

Right-click and drag.

Release the button and "Copy cells"


Gord Dibben MS Excel MVP
 

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.

Ask a Question

Similar Threads

Drag and Drop does not work Outlook for Mac 0
How to make repeating drop-down lists? 2
MS Project. Real progress of the project, % complete 1
Link a text box based on drop down box with four options MS Word 365 0
Student & Home? 1
Line callout arrow in a drawing canvas 1
Excel formula to incrementally increase a value by 1 every 365 day 2
Paragraph numbering in Word 1

Top