Date Formula, End of Year

[EDSTAFF]

Excel 2003, Win XP-MCE

Need this formula modified:

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

Thanks for your help,

L.M.

 

[Greg Truby]

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

 

[EDSTAFF]

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.