| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Contains 29 February
Il giorno venerd́ 17 aprile 2015 10:49:02 UTC+2, ha scritto:
I need to create a formula which will calculate whether the period between two specified dates contains the 29th February and return "Y" or "N". Date one is located in cell B164, date two in cell D164 - the first date will always be earlier than the second. I need to avoid macros as our network securities will not allow them. Any help would be much appreciated! Hi Amy, =INT(SUM(--(DAY(EOMONTH(ROW(OFFSET(INDIRECT("A"&B164),0,0,D16 4-B164+1,1)),0))=29))/29) CSE (Array Formula) -- Ciao! :) Maurizio |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace 29 february with 28 february with vba | Excel Programming | |||
| I need a february 29th row, but only if the day of year actually exists | Excel Worksheet Functions | |||
| Date plus 1 year (february problem) | Excel Worksheet Functions | |||
| When February 29 is date? | Excel Worksheet Functions | |||
| Function works except with January and February? | Excel Programming | |||
![Maurizio Borrelli[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
