Thread: Excluding leap days in a formula
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Excluding leap days in a formula
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
Reply With QuoteReply With Quote