That's a new one on me., Arvi. Live and learn (and learn, and learn)
"Arvi Laanemets" wrote:
Hi
"Duke Carey" wrote in message
...
=DAYS(EOMONTH( target date,0))
to use EOMONTH() you must have the Analysis toolpack add-in loaded
To get the same answer without the Analysis toolpack
=DAY(Date(year(target date), month( target date)+1, 1)-1)
Somewhat shorter version:
=DAY(Date(year(target date), month( target date)+1, 0))
Arvi Laanemets
|