# Date Formula enhancement Needed

#### thhynes

##### New Member
In the image below
... based on the plan year, effective date, metal level, plan name, rating area, and Date of Birth
A Vlookup formula searches a table of data to return the Value based on the information.

This Date formula =IF(MONTH(DATEVALUE(L\$24&"1"))>=MONTH(\$C\$9), \$I26, "")

fills in the rates based on the effective date - which is working well,.. it leaves any month except for the EFFECTIVE month blank and fills in the RATES for
the remaining months.

What I would like to achieve is, and I may need to add a field under the Effective date for Termination Date, then based on these two dates the
rates fill in for the Effective date through the termination Date...

So lets say

Effective date 05/01/2021
Termination date 08/31/2021

the RATE found would only be filled in for the months of May, June, July, August
the months of Jan, Feb, Mar, Apr, Sep, Oct, Nov, Dec

I sort of understand what this formula is doing but not enough to achieve what I would like.

Thanks

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

image

#### Fluff

##### MrExcel MVP, Moderator
Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Cross posted at: Assistant in Adding to this DATE formula
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Replies
11
Views
207
Replies
8
Views
107
Replies
2
Views
65
Replies
0
Views
416
Replies
1
Views
638

1,190,953
Messages
5,983,819
Members
439,862
Latest member
FaisalAlTawil

### 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.

### Which adblocker are you using?

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

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