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

.



Relevant Pages

  • Re: Converting data Format
    ... Delimiter by space. ... Add two helper columns one for Group and one for team. ... VBA Noob ... VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33833 ...
    (microsoft.public.excel.misc)
  • Re: Looping filter criteria
    ... Then use a template with my formulas to paste into. ... My question then is how would I adpat your code to copy the template ... VBA Noob ... VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33833 ...
    (microsoft.public.excel.programming)
  • Re: Loop + Data validation list + e-mail problem
    ... Any help or is the data validation list a red herron ?? ... VBA Noob ... VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33833 ...
    (microsoft.public.excel.programming)
  • Re: Conditional sum
    ... absolutely no need to coerce the array of numbers ... VBA Noob ... VBA Noob's Profile: ...
    (microsoft.public.excel.misc)
  • Re: updating phone number formatting
    ... So say in Col H1 enter the below and drag down ... Next you should get excel paste box options. ... VBA Noob ... VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33833 ...
    (microsoft.public.excel.worksheet.functions)