Re: Need a formula to count the fridays between two dates




Try

=SUM(IF(WEEKDAY(F2-1+ROW(INDIRECT("1:"&TRUNC(F3-F2)+1)))=6,1,0))

It's an array so need to press Crtl + Shitf + enter to work

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33833
View this thread: http://www.excelforum.com/showthread.php?threadid=570107

.