Running Dates based on variables

R

riskier4ra

Board Regular
Joined
Dec 5, 2017
Messages
101
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
 
Sort by date Sort by votes
Ignore as there is still something missing in my logic.
 
Last edited:
Upvote 0

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
What end date would start date of 3rd October and 3rd November produce?
 
Upvote 0
Hello!

Maybe this:

In C2 and copy down:

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

[TABLE="class: grid, width: 416"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]End Date-F[/TD]
[TD]Verify[/TD]
[TD][/TD]
[TD]Fixed Day[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="align: right"]7/5/2017[/TD]
[TD="align: right"]2/7/2018[/TD]
[TD="align: right"]2/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: right"]7/21/2017[/TD]
[TD="align: right"]2/7/2018[/TD]
[TD="align: right"]2/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="align: right"]7/24/2017[/TD]
[TD="align: right"]2/7/2018[/TD]
[TD="align: right"]2/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="align: right"]9/11/2017[/TD]
[TD="align: right"]4/7/2018[/TD]
[TD="align: right"]4/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: right"]10/2/2017[/TD]
[TD="align: right"]4/7/2018[/TD]
[TD="align: right"]4/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="align: right"]10/10/2017[/TD]
[TD="align: right"]5/7/2018[/TD]
[TD="align: right"]5/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: right"]10/23/2017[/TD]
[TD="align: right"]5/7/2018[/TD]
[TD="align: right"]5/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD="align: right"]11/16/2017[/TD]
[TD="align: right"]6/7/2018[/TD]
[TD="align: right"]6/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD="align: right"]11/21/2017[/TD]
[TD="align: right"]6/7/2018[/TD]
[TD="align: right"]6/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="align: right"]12/7/2017[/TD]
[TD="align: right"]7/7/2018[/TD]
[TD="align: right"]7/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD="align: right"]12/28/2017[/TD]
[TD="align: right"]7/7/2018[/TD]
[TD="align: right"]7/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD="align: right"]1/10/2018[/TD]
[TD="align: right"]8/7/2018[/TD]
[TD="align: right"]8/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]***[/TD]
[TD]**********[/TD]
[TD]**********[/TD]
[TD]**********[/TD]
[TD]*******[/TD]
[TD]***[/TD]
[TD]*********[/TD]
[/TR]
</tbody>[/TABLE]


Markmzz
 
Upvote 0
markmzz said:
Hello!

Maybe this:

In C2 and copy down:

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

[TABLE="class: grid, width: 416"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]End Date-F[/TD]
[TD]Verify[/TD]
[TD][/TD]
[TD]Fixed Day[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="align: right"]7/5/2017[/TD]
[TD="align: right"]2/7/2018[/TD]
[TD="align: right"]2/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="align: right"]7/21/2017[/TD]
[TD="align: right"]2/7/2018[/TD]
[TD="align: right"]2/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="align: right"]7/24/2017[/TD]
[TD="align: right"]2/7/2018[/TD]
[TD="align: right"]2/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="align: right"]9/11/2017[/TD]
[TD="align: right"]4/7/2018[/TD]
[TD="align: right"]4/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: right"]10/2/2017[/TD]
[TD="align: right"]4/7/2018[/TD]
[TD="align: right"]4/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="align: right"]10/10/2017[/TD]
[TD="align: right"]5/7/2018[/TD]
[TD="align: right"]5/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="align: right"]10/23/2017[/TD]
[TD="align: right"]5/7/2018[/TD]
[TD="align: right"]5/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD="align: right"]11/16/2017[/TD]
[TD="align: right"]6/7/2018[/TD]
[TD="align: right"]6/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD="align: right"]11/21/2017[/TD]
[TD="align: right"]6/7/2018[/TD]
[TD="align: right"]6/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="align: right"]12/7/2017[/TD]
[TD="align: right"]7/7/2018[/TD]
[TD="align: right"]7/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD="align: right"]12/28/2017[/TD]
[TD="align: right"]7/7/2018[/TD]
[TD="align: right"]7/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD="align: right"]1/10/2018[/TD]
[TD="align: right"]8/7/2018[/TD]
[TD="align: right"]8/7/2018[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]***[/TD]
[TD]**********[/TD]
[TD]**********[/TD]
[TD]**********[/TD]
[TD]*******[/TD]
[TD]***[/TD]
[TD]*********[/TD]
[/TR]
</tbody>[/TABLE]


Markmzz
Click to expand...

That looks like it did it Mark. Thanks for the help!
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Question Question
Selection based on two variables - copy and paste to another sheet
Replies
3
Views
363
kvsrinivasamurthy
K
J
  • Question Question
How to allocate project hours between specific dates using specific daily hour burn rates and including awkward calendar month start/end+holidays
2
Replies
11
Views
2K
felixstraube
F
L
  • Solved
Trouble running an access query in excel vba
Replies
2
Views
155
Legal Tender
L
M
  • Solved
Deleting rows from a Range variable
Replies
4
Views
273
Umma123
U
B
  • Question Question
VBA to show and change list of names depending on selection
Replies
7
Views
736
mumps
mumps

Forum statistics

Threads
1,223,909
Messages
6,175,314
Members
452,634
Latest member
cpostell

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top