Prepopulate dates based on first initial date

[Sjokwaave]

Hi all,

My second and hopefully last question to manage a sheet I've been given to work on. You'll have to forgive an excel noob!

I have a sheet with names in the first column and then dates in the subsequent columns (initial contact date and then 12 dates highlighting when contact is due in each subsequent month over the year, so 13 date columns in total).

Is it possible to format the sheet so that when I input the initial contact date, I can get excel to calculate and input the 12 monthly contact dates for the remaining columns based on the initial contact date?

I should note that there is already a conditional format in the date cells that highlights the cell 7 days before the due date - not sure if this would impact further formatting?

Any help is appreciated.

Thanks.

 

[awoohaw]

If the same day of each month you can use the EDATE and SEQUENCE FUNCTIONS

Mr Excel Questions 71.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1
2
3
4		1st Month	2nd Month	3rd Month	4th Month	5th Month	6th Month	7th Month	8th Month	9th Month	10th Month	11th Month	12th Month	13th Month
5		2023-11-04	2023-12-04	2024-01-04	2024-02-04	2024-03-04	2024-04-04	2024-05-04	2024-06-04	2024-07-04	2024-08-04	2024-09-04	2024-10-04	2024-11-04
6
Sjokwaave2

Cell Formulas
Range	Formula
C5:N5	C5	=EDATE(B5,SEQUENCE(1,12,1,1))
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B5:N5	Expression	=(B5-7)<=TODAY()	text	NO

 

[Sjokwaave]

Lifesaver, thank you!

 

[awoohaw]

I'm happy you found a solution.

-Best Wishes!