Thread: count number of days including weekend

Hi there,

Any one help me please?!

I'm trying to find a suitable function to enable me to count number of days. The trouble is that it has to start on day 1 for example, 01/05/06 to 05/05/06 = 5 days or 01/05/06 to 08/05/06 = 8 days or 30/04/06 to 08/05/06 = 9 days However the execel does not seem to count what i want.

I have tried this =a2-a1 function but will not get what i required as if i put the same date; 01/05/06 to 05/05/06, execel will count 4?!?!

Can any one help me on this one?

Lastly,I'm currently working update the project in my work, and I'm trying to set up that if a job has 'started' e.g rewire, central heating etc, in between 01/04/05 to 31/03/05 = "x" and if 01/04/06 to 31/03/06 = "y", if no work start then leave it blank.

When I use this function,see below:
=if(or(g10<a1,g10<a2),"x","y")

(a1=01/04/05 a2=31/03/05)

if no date has been input, the x or y will come up, is there a way of any dates input = x/y and no date leave it in blank?

I would be grateful for you help.


Craig

Hello craig@help,

Sorry if this is a bit late, but maybe if you had put your question in the Miscellaneous or General forum, someone may have replied before.

The answer to your first question, if you take one date (A1) 01/05/06 away from another date (A2) 05/05/06

=A2-A1, this equals 4, if you want to include all the dates your formula is

=A2-A1+1 this equals 5

With regard to your other question, when you say "if no date input", I'm assuming your referring to cell G10, if that is the case you formula is

=IF(G10="","",IF(OR(G10<A1,G10<A2),"x","y"))

Hope this helps, don't forget to post your next question in the right forum

oldchippy