Running Dates based on variables

[riskier4ra]

Hi everyone,

I have an interesting challenge if anyone is willing to take a look at it. Ive been working on this for several hours, and thought I had it worked out but....

Maybe you beautiful minds can help?

I am trying to get a date that resolves from a another date that is inputted to always be 6 months out but land on a specific day, the 7th to be exact.

Thanks for any help offered,

D

 

[MARK858]

Ignore as there is still something missing in my logic.

 

[MARK858]

What end date would start date of 3rd October and 3rd November produce?

 

[markmzz]

Hello!

Maybe this:

In C2 and copy down:

=EOMONTH($A2+6*30,0)+$F$2

	A	B	C	D	E	F
1	Start Date	End Date	End Date-F	Verify		Fixed Day
2	7/5/2017	2/7/2018	2/7/2018	TRUE		7
3	7/21/2017	2/7/2018	2/7/2018	TRUE
4	7/24/2017	2/7/2018	2/7/2018	TRUE
5	9/11/2017	4/7/2018	4/7/2018	TRUE
6	10/2/2017	4/7/2018	4/7/2018	TRUE
7	10/10/2017	5/7/2018	5/7/2018	TRUE
8	10/23/2017	5/7/2018	5/7/2018	TRUE
9	11/16/2017	6/7/2018	6/7/2018	TRUE
10	11/21/2017	6/7/2018	6/7/2018	TRUE
11	12/7/2017	7/7/2018	7/7/2018	TRUE
12	12/28/2017	7/7/2018	7/7/2018	TRUE
13	1/10/2018	8/7/2018	8/7/2018	TRUE
***	**********	**********	**********	*******	***	*********

<tbody>
</tbody>

Markmzz

 

[riskier4ra]

Hello!

Maybe this:

In C2 and copy down:

=EOMONTH($A2+6*30,0)+$F$2

	A	B	C	D	E	F
1	Start Date	End Date	End Date-F	Verify		Fixed Day
2	7/5/2017	2/7/2018	2/7/2018	TRUE		7
3	7/21/2017	2/7/2018	2/7/2018	TRUE
4	7/24/2017	2/7/2018	2/7/2018	TRUE
5	9/11/2017	4/7/2018	4/7/2018	TRUE
6	10/2/2017	4/7/2018	4/7/2018	TRUE
7	10/10/2017	5/7/2018	5/7/2018	TRUE
8	10/23/2017	5/7/2018	5/7/2018	TRUE
9	11/16/2017	6/7/2018	6/7/2018	TRUE
10	11/21/2017	6/7/2018	6/7/2018	TRUE
11	12/7/2017	7/7/2018	7/7/2018	TRUE
12	12/28/2017	7/7/2018	7/7/2018	TRUE
13	1/10/2018	8/7/2018	8/7/2018	TRUE
***	**********	**********	**********	*******	***	*********

<tbody>
</tbody>

Markmzz

That looks like it did it Mark. Thanks for the help!

 

[markmzz]

That looks like it did it Mark. Thanks for the help!

I'm glad to help and thanks for the feedback.

Markmzz