F Filipemr Mar 17, 2008 #1 there exists a function for calculate "endmonth"! Is there another one to calculate in the same way "endyear"?
there exists a function for calculate "endmonth"! Is there another one to calculate in the same way "endyear"?
B Bob Phillips Mar 17, 2008 #2 =DATE(YEAR(TODAY()),12,31) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
=DATE(YEAR(TODAY()),12,31) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
