| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a formula to count the fridays between two dates
Thanks. I used that and it worked for me. I was pretty amazed, I'm still
trying to figure it out. "VBA Noob" wrote: 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 + ****f + enter to work VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=570107 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How To Calculate the Number of Fridays between two dates. | Excel Discussion (Misc queries) | |||
| Formula to get number of days excluding Fridays in a given period | Excel Worksheet Functions | |||
| a formula that returns the previous fridays date | Excel Worksheet Functions | |||
| formula for last Fridays date | Excel Discussion (Misc queries) | |||
| count work days excluding Fridays and Saturdays ??? | Excel Worksheet Functions | |||
Threaded Mode
