# Date Formula, End of Year

#### EDSTAFF

##### New Member
Excel 2003, Win XP-MCE

Need this formula modified:
Code:
``````=IF(OR(C12=0,D12=0,E12=0,F12=0),"",DATE(YEAR(E12),MONTH(E12)+(F12),DAY(E12)))

where E12 is current certification date in Y/M/D format. F12 is term of certification (length of term variable). C12:D12 is other information that, if absent, results in a blank return of calculation.

Certification/Class date is not totally dependent on 12 month term; it simply has to occur each calendar year. For instance, if one took the class  January 1 of 2005, one would would not be REQUIRED to take the class again until the following calendar year (2006)...as late as 12/31/2006, a span of almost 2 years. However, if one took the class December 31 of 2005, classtime MUST be repeated by December 31 of 2006, a span of 12 months.

I realize the F12 needs to come out of the equation, leaving me with a formula needed to calculate next END OF YEAR. I will probablly leave the F12 as a stand-alone result simply as a reference point but not as part of the larger equation.

L.M.``````

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
I'm still a little fuzzy on your requirement, but sounds like you simply need<ul>[*]=Date(Year(E12)+1,12,31)[/list]

Greg Truby said:
I'm still a little fuzzy on your requirement, but sounds like you simply need<ul>[*]=Date(Year(E12)+1,12,31)[/list]

Thanks, that works. And I was expecting some long complex formula... and get surprised with a simple EOY formula.

Thanks again,

L.M.

Replies
0
Views
73
Replies
6
Views
143
Replies
4
Views
250
Replies
3
Views
362
Replies
2
Views
227

1,196,359
Messages
6,014,798
Members
441,847
Latest member
hw407

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