| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find the most future date | Excel Discussion (Misc queries) | |||
| Find closest future date from list ... | Excel Discussion (Misc queries) | |||
| save as future date eg expected delivery date | Excel Discussion (Misc queries) | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Hybrid Mode
