Home |
Search |
Today's Posts |
#1
|
|||
|
|||
dates - automatically fill next day
Hi there - I am a new user, have only started using excel 2 days ago but am really enjoying it. I have managed to create timesheets that automatically calculate the time spent on a project. Anyway, enjoying it very much. So, I have dates running down the left hand column (A), eg, 05.10.05. Currently I am inputting these by hand because if I drag that cell down it creates 05.10.06, 05.10.07 etc. I have messed with the 'custom' setting and changed it to 'dd.mm.yy' but this has not solved it. Any help much appreciated. By the way, it's excel 2001 for mac. Tom -- small tom ------------------------------------------------------------------------ small tom's Profile: http://www.excelforum.com/member.php...o&userid=27828 View this thread: http://www.excelforum.com/showthread...hreadid=473342 |
#2
|
|||
|
|||
Could you live with the data in format dd/mm/yy ?
Then dragging the cell increments the date by 1 Have you tried putting a date in A1 and in A2 enter =A1+1 ? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "small tom" wrote in message ... Hi there - I am a new user, have only started using excel 2 days ago but am really enjoying it. I have managed to create timesheets that automatically calculate the time spent on a project. Anyway, enjoying it very much. So, I have dates running down the left hand column (A), eg, 05.10.05. Currently I am inputting these by hand because if I drag that cell down it creates 05.10.06, 05.10.07 etc. I have messed with the 'custom' setting and changed it to 'dd.mm.yy' but this has not solved it. Any help much appreciated. By the way, it's excel 2001 for mac. Tom -- small tom ------------------------------------------------------------------------ small tom's Profile: http://www.excelforum.com/member.php...o&userid=27828 View this thread: http://www.excelforum.com/showthread...hreadid=473342 |
#3
|
|||
|
|||
Thanks - think I just sorted it by starting at the point you gave me. This still didn't quite work as it changed it to mm/dd automatically but I went in and swapped it to 14-march-05 and now it will autofill when dragging it. Thanks for the point in the right direction - am sure I will be bothering you again. Tom -- small tom ------------------------------------------------------------------------ small tom's Profile: http://www.excelforum.com/member.php...o&userid=27828 View this thread: http://www.excelforum.com/showthread...hreadid=473342 |
#4
|
|||
|
|||
Here to help but I'm off on vacation for a few weeks
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "small tom" wrote in message ... Thanks - think I just sorted it by starting at the point you gave me. This still didn't quite work as it changed it to mm/dd automatically but I went in and swapped it to 14-march-05 and now it will autofill when dragging it. Thanks for the point in the right direction - am sure I will be bothering you again. Tom -- small tom ------------------------------------------------------------------------ small tom's Profile: http://www.excelforum.com/member.php...o&userid=27828 View this thread: http://www.excelforum.com/showthread...hreadid=473342 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill automatically from one worksheet to another based on cel valu | Excel Discussion (Misc queries) | |||
CUSTOM FILL USING DATES | New Users to Excel | |||
automatically fill in a range of cells | Excel Discussion (Misc queries) | |||
Why won't it Excel fill in weekly dates now, changes them to daily | Excel Worksheet Functions | |||
Dates that automatically update ... | Excel Discussion (Misc queries) |