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.