Not including weekends?

Hi,

I have a spreadsheet that I am working on, two of the columns are 'Entry Date' & 'Completion Date' the third column I have a sum taking 'Completion Date' away from 'Entry Date' giving me a number of days to complete a job. What I need is for the third column not to include weekends, which I imagine is a tad more complicated than the sum that I am using.

Is there a formula that I can use?

Kind regards,

Andy

Hi,

Thankyou for your responce,

If I open a new sheet and put your dates in A1 and B1 and =NETWORKDAYS(A1,B1) in C1 it works YEY!

However, transposing it to my spread sheet where the cells are C1 and D1 so I enter in E1 =NETWORKDAYS(C1,D1) the result I get is #Name?

The date format is the same, any ideas?

Regards,

Andy.

DOH!!!!

I typed in NETWORDAYS!!!!!

Sorry!

All working now, thank you very much,

Regards,

Andy