Excel Formula 1

[TSHDave]

I need to beable to produce a value that count the number of days between two dates and takeaway the number of saturdays.

 

[bluedragon2]

try:

=(B1-A1-(7-WEEKDAY(A1))-WEEKDAY(B1))-((B1-A1-(7-WEEKDAY(A1))-WEEKDAY(B1))/7)+(6-WEEKDAY(A1))+(IF(WEEKDAY(B1)=7,6,WEEKDAY(B1)))

where start date is a1 and end date is b1



Blue

If I wasn't Blue, I would just be a Dragon...

 

[bluedragon2]

Slight adjustment for starting dates begining on a Sat:

=(B1-A1-(7-WEEKDAY(A1))-WEEKDAY(B1))-((B1-A1-(7-WEEKDAY(A1))-WEEKDAY(B1))/7)+(IF(WEEKDAY(A1)=7,0,(6-WEEKDAY(A1))))+(IF(WEEKDAY(B1)=7,6,WEEKDAY(B1)))



Blue

If I wasn't Blue, I would just be a Dragon...

 

[KenWright]

Start Date in A1, Finish date in B1

=B1-A1-SUM(IF(WEEKDAY(A1-1+ROW(INDIRECT("1:"&TRUNC(B1-A1)+1)))=7,1,0))+1

Array entered

Regards
Ken................

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------

 

[KenWright]

Just in case - 'Array entered' means enter the formula using CTRL+SHIFT+ENTER at the same time.

You are limited though to date intervals of a max of about 180 years

Regards
Ken...............

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------

 

[aldior]

=(B4-B4/(7)) if b4=B1-A1 is just fairly accurate.