sorry,
e.g.
passed Thus & Fris:
=INT((E4-D1+WEEKDAY(D1-4,3)+1)/7) + INT((E4-D1+WEEKDAY(D1-5,3)+1)/7)
-- =SUM(INT((E4-D1+WEEKDAY(D1-{4,5},3)+1)/7))


"MRT" wrote in message ...
e.g. passed Thus & Fris:
=INT((E4-D1+WEEKDAY(D1-4,3)+1)/7) + INT((E4-D1+WEEKDAY(D1-5,3)+1)/7)
-- =SUM(INT((C13-B13+WEEKDAY(B13-{4,5},3)+1)/7))

HTH
--
MRT

"Abdul" wrote in message ...
Thanks,

There is no cut short to use more than one day at a time? Like both
Thursday and Friday or any other combination (In a single formulae)?

Abdul


On Nov 8, 1:05 pm, "MRT" wrote:
passed Weds: .....D1-3.....
passed Thus: .....D1-4.....
passed Fris: .....D1-5.....

remaing Weds: .....E4-3.....
remaing Thus: .....E4-4.....
remaing Fris: .....E4-5.....

HTH
--
MRT

"Abdul" wrote in ...

How I can Modify this formula to get days passed and remaing excluding
both Thursdays and Fridays?

Thanks,

On Nov 6, 5:15 pm, MRT wrote:

passed: =E4-D1+1-INT((E4-D1+WEEKDAY(D1-5,3)+1)/7)
remains: =C1-E4-INT((C1-E4+WEEKDAY(E4-5+1,3))/7)

HTH
--
MRT

"Abdul" wrote:
Hi,

I am using the following formula to get number of days passed
excluding Fridays in a given Month from fisrt date to the given date
(today)

=(E4-D1+1)-(INT((E4-D1)/7)+IF(WEEKDAY(D1)+MOD(E4-D1,7)=6,1,0))

Where E4 is the end date (today) and D1 start date of the Month

and also Number of days remaing in the month excluding Fridays from
today till end of month.

=(C1-E4)-(INT((C1-(E4+1))/7)+IF(WEEKDAY(E4)+MOD(C1-(E4+1),7)=6,1,0))

Where E4 is the start date and C1 is the end date

Some how it is not working for all days.. some times it gives 1 day
difference.

It is the same case if I use a formula like this
=SUM(IF(ISERROR(MATCH(WEEKDAY(ROW(INDIRECT(E4&":"& B1))),{6},0)),
1,0))-1

of course the cell address is different in above example.

Is there a better workaround?

Thanks
.