Live Chat & Podcast at 1:00PM Eastern on Sunday!
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Business Applications
Go to first new post Fill excel Columns from word files
Go to first new post Solved: Combining 2 worksheets into 1
Go to first new post Solved: Excel Data Validation
Go to first new post MS Access VBA - Convert Word to PDF
Go to first new post ComboBox List Table sort order
Go to first new post Product Key Invalid
Go to first new post Excel Email Macro
Go to first new post Outlining/Grouping for Protected Excel W ...
Go to first new post Excel Macro
Go to first new post Solved: Winword 32 remains running hogs ...
Go to first new post Macro to find duplicate values in column ...
Go to first new post Access 2010 database
Go to first new post Cant open Excel and PDF files
Go to first new post Word 2007 opens previous document
Go to first new post Solved: Sending a Automated Email Throug ...
Tag Cloud
access acer asus bios bsod computer crash desktop drive driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop malware memory missing monitor motherboard network printer problem ram random registry router slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless
Search
Search for:
Tech Support Guy Forums > Software & Hardware > Business Applications >
Solved: excel date formula - ignore weekends

Reply  
Thread Tools
higginsbl's Avatar
Member with 121 posts.
  
Join Date: Aug 2001
02-Apr-2009, 03:09 PM #1
Solved: excel date formula - ignore weekends
Is there a way to write a formula that adds down the column 1 day to the previous day, but when it hits a Saturday or a Sunday, it goes to Monday?
ie: (a1+1) but by the time it got to April 3 it would know to add 3 to get to Monday
Monday, March 30, 2009
Tuesday, March 31, 2009
Wednesday, April 01, 2009
Thursday, April 02, 2009
Friday, April 03, 2009
Saturday, April 04, 2009
Sunday, April 05, 2009
Monday, April 06, 2009
Tuesday, April 07, 2009

Thanks for any information you can provide.

BL
Register for free to hide this ad!
Gregor1234's Avatar
Member with 236 posts.
  
Join Date: Jun 2004
Experience: Intermediate
02-Apr-2009, 03:17 PM #2
try:

=a1+IF(WEEKDAY(a1)=6,3,1)

If WEEDAY of previous cell = 6 (=Friday) then add 3 else add 1
Aj_old's Avatar
Computer Specs
Senior Member with 869 posts.
  
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
03-Apr-2009, 08:51 AM #3
use this :
Code:
=WORKDAY(A1;1)
higginsbl's Avatar
Member with 121 posts.
  
Join Date: Aug 2001
03-Apr-2009, 12:13 PM #4
Smile date formula
Hurray! Thanks so much!
Email This Email  Print This Print  Tweet This Send to Facebook Send to MySpace Send to StumbleUpon Digg This | More Services More
Reply

Tags
dates, excel, formulas

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!

« Previous Thread | Business Applications | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
Contact Us - HelpOnThe.Net - Archive - Terms of Service - Top
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 03:35 AM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

 Powered by Cermak Technologies, Inc.