Removing weekends from calendar days

[tlb]

Help!!! I'm having tons of trouble when it comes to this piece of excel heaven and cannot figure this out. My excel spreadsheet currently has a cell labeled [Days_Since_Received] and excel is figuring time in the system in Calendar Days. I need it to calculate into Work Days (M-F) or Business days.

I have tried =Workday but all this does is ADD a date instead of subtracting the number of days. I really need it to SUBRACT the weekend(s) and place a number of days in there. I don't care if I have to do multiple columns but this is killing me! HELP PLEASE!!!

Example using =workday formula:

Received_Datetime	Days_Since_Received	Business Days
8/29/2012 12:12	9	9/11/2012

<TBODY>
</TBODY>

It should look like the following:

Received_Datetime	Days_Since_Received	Business Days
8/29/2012 12:12	9	7

<TBODY>
</TBODY>

 

[Oaktree]

Welcome to the board!

Have a look at the NETWORKDAYS function in Excel help.

 

[barry houdini]

Try NETWORKDAYS

If Received_Datetime is in A2 use this formula to get business days up to today. It includes both A2 and today

=NETWORKDAYS(A2,TODAY())

 

[rallcorn]

Since 7 is the answer you arrive at manualy, it appears you're excluding today and Labor Day:
=NETWORKDAYS(A1,(TODAY()-1),9/3/12)

 

[tlb]

=NETWORKDAYS(A1,(TODAY()-1) definitely worked for me but now I have another issue. All of my items for today's day are showing at -2. Is there a way to have these default to zero? Thanks!

 

[barry houdini]

Try this version instead

=NETWORKDAYS(A1,TODAY())-1

 

[HankPym]

My issue was showing dates for only work days. So sequentially listing dates, no Saturdays, or Sundays popping up.

=IF(WEEKDAY(A1+1,2)=6,A1+3,A1+1)

The formula just skips the weekends.