6 Day working week (friday holiday)

D

Dan Johns

Hieveryone,

I am an excell novice trying to put together a project calculation sheet. I need to calculate total days between 2 dates excluding each and every friday. (middle east, they like to be different) My dates refer to job start and finish and i need the number of working days to automatically calculate costs on a lower table. I have seen an aray of suggestions but i cant get them to work to suit my requirements. (just calculating 6 out of seven days dosent help as a 3 day job falling over a friday will show a 4 day duration. My dates are input from a Developer tab 'date and time picker' and linked to a normal cell in standard date format. NETWORKINGDAYS as you know calculates with SAT and SUN off.

is there any way to add a new formular or modify an existing...??? if not any crack at a solution would be great.

all help appreciated.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Document Compatibility in Internet Explorer 8
http://www.eggheadcafe.com/tutorial...b-a7cd299b73c9/document-compatibility-in.aspx
 
D

Dan Johns

Hi everyone,

I am an excell novice trying to put together a project
calculation sheet. I need to calculate total days
between 2 dates excluding each and every friday.
(middle east, they like to be different) My dates refer
to job start and finish and i need the number of working
days to automatically calculate costs on a lower table.
I have seen an aray of suggestions but i cant get them
to work to suit my requirements. (just calculating 6 out
of seven days dosent help as a 3 day job falling over a
friday will show a 4 day duration. My dates are input
from a Developer tab 'date and time picker' and linked
to a normal cell in standard date format. NETWORKINGDAYS
as you know calculates with SAT and SUN off.

is there any way to add a new formular or modify an
existing...??? if not any crack at a solution would be great.

all help appreciated.



Dan Johns wrote:

6 Day working week (friday holiday)
09-Jan-10

Hieveryone,

I am an excell novice trying to put together a project calculation sheet. I need to calculate total days between 2 dates excluding each and every friday. (middle east, they like to be different) My dates refer to job start and finish and i need the number of working days to automatically calculate costs on a lower table. I have seen an aray of suggestions but i cant get them to work to suit my requirements. (just calculating 6 out of seven days dosent help as a 3 day job falling over a friday will show a 4 day duration. My dates are input from a Developer tab 'date and time picker' and linked to a normal cell in standard date format. NETWORKINGDAYS as you know calculates with SAT and SUN off.

is there any way to add a new formular or modify an existing...??? if not any crack at a solution would be great.

all help appreciated.

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET Excel Workbooks, ADO.NET, Message Queue
http://www.eggheadcafe.com/tutorial...8e75-bd6cf2ab3a22/aspnet-excel-workbooks.aspx
 
R

Roger Govier

Hi Dan

The following will give you a count of the total number of day that are not
Friday, in the range A1:A31.
Change ranges to suit

=SUMPRODUCT(--(WEEKDAY(A1:A31)<>5),--(A1:A31<>""))

--
Regards
Roger Govier

Hi everyone,

I am an excell novice trying to put together a project
calculation sheet. I need to calculate total days
between 2 dates excluding each and every friday.
(middle east, they like to be different) My dates refer
to job start and finish and i need the number of working
days to automatically calculate costs on a lower table.
I have seen an aray of suggestions but i cant get them
to work to suit my requirements. (just calculating 6 out
of seven days dosent help as a 3 day job falling over a
friday will show a 4 day duration. My dates are input
from a Developer tab 'date and time picker' and linked
to a normal cell in standard date format. NETWORKINGDAYS
as you know calculates with SAT and SUN off.

is there any way to add a new formular or modify an
existing...??? if not any crack at a solution would be great.

all help appreciated.



Dan Johns wrote:

6 Day working week (friday holiday)
09-Jan-10

Hieveryone,

I am an excell novice trying to put together a project calculation sheet.
I need to calculate total days between 2 dates excluding each and every
friday. (middle east, they like to be different) My dates refer to job
start and finish and i need the number of working days to automatically
calculate costs on a lower table. I have seen an aray of suggestions but i
cant get them to work to suit my requirements. (just calculating 6 out of
seven days dosent help as a 3 day job falling over a friday will show a 4
day duration. My dates are input from a Developer tab 'date and time
picker' and linked to a normal cell in standard date format.
NETWORKINGDAYS as you know calculates with SAT and SUN off.

is there any way to add a new formular or modify an existing...??? if not
any crack at a solution would be great.

all help appreciated.

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET Excel Workbooks, ADO.NET, Message Queue
http://www.eggheadcafe.com/tutorial...8e75-bd6cf2ab3a22/aspnet-excel-workbooks.aspx

__________ Information from ESET Smart Security, version of virus
signature database 4756 (20100109) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top