View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
PMBO PMBO is offline
external usenet poster
 
Posts: 10
Default 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