Asked by murbro
at 2024-07-20 08:47:28
Point:500 Replies:8 POST_ID:829037USER_ID:11939
Topic:
Microsoft Excel Spreadsheet Software;;
21/07/2007
21/07/2008
In copying the first cell above I wanted the second cell to be a day after but instead it is a year after. How can I
set things up so that when I drag the little cross that appears at the corner of the cell it increments by a day?
21/07/2008
In copying the first cell above I wanted the second cell to be a day after but instead it is a year after. How can I
set things up so that when I drag the little cross that appears at the corner of the cell it increments by a day?
Author: murbro replied at 2024-07-24 11:36:45
Thanks for the help
Assisted Solution
Expert: Rob Henson replied at 2024-07-23 05:14:23
125 points EXCELLENT
1) Change the cell format of the first cell to
dd/mm/yyyy
using the Format Cells dialog (shortcut: [Ctrl]+[1])
dd/mm/yyyy
using the Format Cells dialog (shortcut: [Ctrl]+[1])
2) Select the cell and click and drag the small cross/square down.
Excel needs to know that the date format is not the regional default (mm/dd/yyyy) in order to do this copy-down-fill process properly.
Regards,
-Glenn
Assisted Solution
Expert: Glenn Ray replied at 2024-07-20 17:36:46
125 points EXCELLENT
1) Change the cell format of the first cell to
dd/mm/yyyy
using the Format Cells dialog (shortcut: [Ctrl]+[1])
dd/mm/yyyy
using the Format Cells dialog (shortcut: [Ctrl]+[1])
2) Select the cell and click and drag the small cross/square down.
Excel needs to know that the date format is not the regional default (mm/dd/yyyy) in order to do this copy-down-fill process properly.
Regards,
-Glenn
Assisted Solution
Expert: als315 replied at 2024-07-20 10:28:32
125 points EXCELLENT
Your system date parameters had to be set to DD/MM/YYYY, only in this case day could be added.
Try to change format of cell to Number. I think it will not be changed.
Try included sample
Try to change format of cell to Number. I think it will not be changed.
Try included sample
Accepted Solution
Expert: duncanb7 replied at 2024-07-20 10:04:34
125 points EXCELLENT
just try at A2 cell so that can make day increment on the date
from a1 =21/07/2007
=a1+1 and drag cells
Ducan
from a1 =21/07/2007
=a1+1 and drag cells
Ducan
Author: murbro replied at 2024-07-20 09:59:45
Hi. Thanks, but both don't work
Expert: duncanb7 replied at 2024-07-20 09:47:02
Select the date on cell format to
*14/01/2001 or *xx/yy/zzzz
Drag the cell again
Duncan
*14/01/2001 or *xx/yy/zzzz
Drag the cell again
Duncan
Expert: Glenn Ray replied at 2024-07-20 09:34:35
1) Change the cell format of the first cell to
dd/mm/yyyy
using the Format Cells dialog (shortcut: [Ctrl]+[1])
dd/mm/yyyy
using the Format Cells dialog (shortcut: [Ctrl]+[1])
2) Select the cell and click and drag the small cross/square down.
Excel needs to know that the date format is not the regional default (mm/dd/yyyy) in order to do this copy-down-fill process properly.
Regards,
-Glenn
