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:
[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]Received_Datetime[/TD]
[TD]Days_Since_Received [/TD]
[TD]Business Days
[/TD]
[/TR]
[TR]
[TD]8/29/2012 12:12 [/TD]
[TD]9 [/TD]
[TD] 9/11/2012
[/TD]
[/TR]
</TBODY>[/TABLE]

It should look like the following:
[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]Received_Datetime[/TD]
[TD]Days_Since_Received [/TD]
[TD]Business Days
[/TD]
[/TR]
[TR]
[TD]8/29/2012 12:12 [/TD]
[TD]9 [/TD]
[TD]7[/TD]
[/TR]
</TBODY>[/TABLE]

 

[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.