dates - automatically fill next day

[small tom]

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

 

[Bernard Liengme]

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

 

[small tom]

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

 

[Bernard Liengme]

Here to help but I'm off on vacation for a few weeks