ExcelBanter - Consecutive Date Formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Consecutive Date Formulas (https://www.excelbanter.com/excel-discussion-misc-queries/21999-consecutive-date-formulas.html)

Codye

Consecutive Date Formulas

How do you enter a date (4/17/05) in column A and it will automatically enter
the next 6 days in Columns B-G?

Hi

In B1 put
=A1+1
and fill this across to G.

--
Andy.

"Codye" wrote in message
...
How do you enter a date (4/17/05) in column A and it will automatically
enter
the next 6 days in Columns B-G?

All times are GMT +1. The time now is 07:01 AM.