DATES - Microsoft Community

enter date , copy date next row without changes being made. 

i not sure version of excel using. however, can achieved in multiple ways..

1.     a. select cells wish enter/copy same date

        b. type date wish , press ctrl+enter

    fill same date in cells selected

2.     a. type date wish , press enter

        b. drag down using right click (and not used left click)

        c. dragging right-click (right button of mouse) pop-up box in which

            1 of options "copy cells"

        d. select "copy cells" option

hope helps.

Office / Excel / Windows 10 / Office 2010