ExcelBanter - How to find a date in the future

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

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

- - How to find a date in the future (https://www.excelbanter.com/excel-worksheet-functions/454580-how-find-date-future.html)

How to find a date in the future

In 2020 February 29 is a Saturday in an uneven week. Next tinme that happens is in 2048, then again in 2076, then in 2116, 2144 and so on. But is there a formula that can calculate this?

How to find a date in the future

Hi,

Am Thu, 20 Feb 2020 22:44:41 -0800 (PST) schrieb Daddy Sage:

In 2020 February 29 is a Saturday in an uneven week. Next tinme that happens is in 2048, then again in 2076, then in 2116, 2144 and so on. But is there a formula that can calculate this?

try:
=SMALL(IF((WEEKDAY(TODAY()+ROW($1:$500000))=7)*(DA Y(TODAY()+ROW($1:$500000))=29)*(MONTH(TODAY()+ROW( $1:$500000))=2),TODAY()+ROW($1:$500000)),ROW(A1))
insert the formula with CRTL+Shift+Enter and copy down.

Regards
Claus B.
--
Windows10
Office 2016