Count days between dates for a part-time worker

[catbrier]

I work only on Wednesdays and Thursdays. I'd like to calculate the number of my working days between two dates.

NETWORKDAYS seems like the right place to start, but I can't think of how to tell it to ignore Mondays, Tuesdays and Fridays as well as the weekend days.

Thanks,
Melanie

[ConneXionLost]

Assuming your start date is in cell A2, and end date in A3, then try:

Please Login or Register  to view this content.

Cheers,

[daddylonglegs]

This formula would give you that result

=SUM(INT((WEEKDAY(A2-{4,5})+A3-A2)/7))

[day92]

Im sure their is an easier way to do this but this should work..

Please Login or Register  to view this content.

[catbrier]

You people rock! Thanks for your helpful solutions. I'll fiddle around with all three until I understand them.

Thanks,
Melanie

[dgriffiths]

Hi, i was wondering if anyone could help me. I am having a similar problem to the above but i have just hit on a small snag. For full time workers i am using a NETWORKDAYS forumla:

(=IF(A11="","",NETWORKDAYS(A11,B11,'Bank Holiday list'!$A$2:$A$40)))

This is really useful as it allows me to exclude bank holidays and forced closure days. However i am now trying to create a formula which will allow me to do the same thing for part time workers. I have just tried daddylonglegs formula from above and this is working really well apart from not excluding bank holidays, is there any way to tweak it to do this?

Many thanks

Derrick