Identifiying Date Ranges

[iSticks]

Hey all,

I'm new to the forum but now I've found it I expect I'll be on here allot hehe.

I recently started a job in which excel is starting to take a huge role. I'm normally a hands on person working on the tools but my new position requires a certain amount of office work.

I have however used excel in the past and am reasonably competent with office programs.

My question to you is:

I want to create a worksheet which records where I've worked throughout the year and for who. The first stage of this requires me to work out which workdays were during the week and which were at weekends (for wage rate reasons)

Basically I will have a [From date] column and a [To date] column for each job and I would like excel to automatically work out the number of weekdays and the number of weekend days within that range. Is this possible?

Thanks in advance for any help.

Dave

EDIT:

Thanks for the help. I managed to do it by getting a number for weekdays using =NETWORKDAYS as suggested and the converted both dates to excel serial numbers, subtracted [to] from [from], added 1 to make up for the missing day, and then subtracted number of weekdays from result to give me the number of weekend days

I'll upload the spreadsheet example when I get home incase it comes in handy for anyone else!

[jeffreybrown]

Hello & Welcome to the Forum,

Starting out with the basic, try...

=NETWORKDAYS(start_date,end_date,holidays)