General discussion


Excel 2000, Auto Date

By MadDogDr ·
I am working with a simple medical type form which is based upon daily medications. Is it possible to utilize a formula that will automatically change the date in the adjacent 6 column cells, to the next day date, when the date short cut (ctrl+ is utilized in the first date entry cell? IE; Date entered in B2, and B3 thru B8 will advance one day automatically.
If this is possible in Excel 2000, how would I accomplish this?
Thanks much in advance for any help afforded.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to Excel 2000, Auto Date

Enter =B2+1 in B3 then grab ahold of the Fill handle (the small square in the lower right corner of the active cell and pull down as far as is necessary.
If you only want the extended dates to show when a entry is made in B3, then use the formula:
And fill that formula down.
(You should not need to, but the cells can be formatted as dates. They should display OK)

Collapse -

by MadDogDr In reply to

Thank you so much for your input. Your formulas worked perfectly for my application. You saved my day!!

Collapse -

by MadDogDr In reply to Excel 2000, Auto Date

This question was closed by the author

Related Discussions

Related Forums