How to automatically fill rows with dates based on cell value?

Hi Everyone. I have a spreadsheet that looks like this: How can I make it for whatever number I put in B2 it takes the date in A4 and extends it by the number of months from B2 and a...

excel

Formulas and Functions

Macros and VBA

Haytham Amairah
Nov 20, 2018
Hi,

I think the most robust way to do this is as follows:
Link cell A4 to the cell B2 by just using this formula in cell A4 =B2
Then use this formula in the cell A5 =IF(ROW(A1)>=$B$1,"",EDATE($A$4,ROW(A1)))
And then drag it down to whatever limit you want

Please find this in the attached file.
Hope that helps
Automatically fill rows with dates based on cell value.xlsx15 KB

Haytham Amairah

Silver Contributor

Nov 20, 2018

Hi,

I think the most robust way to do this is as follows:

Link cell A4 to the cell B2 by just using this formula in cell A4 =B2
Then use this formula in the cell A5 =IF(ROW(A1)>=$B$1,"",EDATE($A$4,ROW(A1)))
And then drag it down to whatever limit you want

Please find this in the attached file.

Hope that helps

Automatically fill rows with dates based on cell value.xlsx15 KB