Results 1 to 3 of 3

need excel to look at weekdays

Threaded View

ExcelBeginner85 need excel to look at weekdays 11-11-2013, 07:48 AM
Fotis1991 Re: need excel to look at... 11-11-2013, 07:56 AM
ragulduy Re: need excel to look at... 11-11-2013, 07:58 AM
  1. #1
    Registered User
    Join Date
    10-28-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    6

    need excel to look at weekdays

    Hi could someone help me please as I am very new to excel. I have a sheet that when I enter a receipt number in column B column A automatically enters today's date and column C automatically enters date of expected completion (+ 5 days of column A) but this includes weekends. How can I get excel to look at only working days I.e. mon-fri ? I will attach the work sheet for you to have a look at.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel Formula to calculate working hours between two dates excluding weekdays with wh
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-28-2013, 11:20 AM
  2. Weekdays, I wish!
    By AlanWade in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 06-20-2008, 05:47 AM
  3. Excel Count Weekdays Formula
    By Ziggy M in forum Excel General
    Replies: 9
    Last Post: 07-14-2006, 08:10 PM
  4. Excel Formula WEEKNUM only works on weekdays 1 and 2, why?
    By Geocyclist in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-09-2005, 10:06 PM
  5. [SOLVED] Recognizing weekends and changing to weekdays in Excel
    By hanauer in forum Excel General
    Replies: 2
    Last Post: 01-07-2005, 11:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1