ExcelBanter - date function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - date function (https://www.excelbanter.com/excel-worksheet-functions/180394-date-function.html)

Filipemr

date function

there exists a function for calculate "endmonth"! Is there another one to
calculate in the same way "endyear"?

Bob Phillips

date function

=DATE(YEAR(TODAY()),12,31)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Filipemr" wrote in message
...
there exists a function for calculate "endmonth"! Is there another one to
calculate in the same way "endyear"?

All times are GMT +1. The time now is 03:33 PM.