R Ron Rosenfeld May 5, 2010 #2 can this be do this easily Click to expand... Here's one way: =SUMPRODUCT(--(TEXT(ROW(INDIRECT(StartDt&":"&EndDt)),"mmdd")="0229")) StartDt and EndDt refer to two cells which contain the starting and ending date of the range you are checking. --ron
can this be do this easily Click to expand... Here's one way: =SUMPRODUCT(--(TEXT(ROW(INDIRECT(StartDt&":"&EndDt)),"mmdd")="0229")) StartDt and EndDt refer to two cells which contain the starting and ending date of the range you are checking. --ron
B Bob Phillips May 5, 2010 #3 Try this =SUMPRODUCT(--(TEXT(ROW(INDIRECT(A1&":"&A2)),"dd-mmm")="29-Feb"))
G Gary''s Student May 5, 2010 #4 With dates in A1 and A2: =A2-A1-(DATE(2003,MONTH(A2),DAY(A2)) -DATE(2003,MONTH(A1),DAY(A1)))-365*(YEAR(A2)-YEAR(A1)) format the cell as Integer So if A1 and A2 contain: 1/18/1945 7/7/2007 the formula will return 15 See J.E. McGimpsey's reply in http://groups.google.com/group/micr...70c49c51b098db?q="number+of+leap+days"+excel#
With dates in A1 and A2: =A2-A1-(DATE(2003,MONTH(A2),DAY(A2)) -DATE(2003,MONTH(A1),DAY(A1)))-365*(YEAR(A2)-YEAR(A1)) format the cell as Integer So if A1 and A2 contain: 1/18/1945 7/7/2007 the formula will return 15 See J.E. McGimpsey's reply in http://groups.google.com/group/micr...70c49c51b098db?q="number+of+leap+days"+excel#
