General discussion
November 11, 2003 at 02:26 PM
maddogdr

Excel 2000, Auto Date

by maddogdr . Updated 22 years, 10 months ago

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 discussion is locked

All Comments