Excluding leap days in a formula
Fantastic - It works perfectly. Thank You Ron.
"Ron Rosenfeld" wrote:
On Thu, 11 Dec 2008 05:28:06 -0800, PMBO
wrote:
Ron -
I'm using a simple datedif =DATEDIF(A1,A2,"d")
This should work:
=SUMPRODUCT(--(((MONTH(ROW(INDIRECT(StartDt&":"&EndDt)))<2)+
(DAY(ROW(INDIRECT(StartDt&":"&EndDt)))<29))0))
--ron
|