Results 1 to 3 of 3

Return Next working Day

Threaded View

  1. #1
    Registered User
    Join Date
    12-14-2009
    Location
    Nottingham
    MS-Off Ver
    Microsoft D365
    Posts
    93

    Return Next working Day

    Hi there, I think this may be impossible but what I am hoping to do is in B3 Return the date that is 3 working days before the date in B2. Working days being Monday to Friday in this case. so if the date in B2 is the 16/04/2014 3 days before this is the 13/04/2014 which is a Saturday so i would want the formula to return the 12/04/2014 which is the Friday

    Is this possible?
    Attached Files Attached Files
    Last edited by Notters; 04-08-2014 at 09:21 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VLookup to return value for time hh:mm not working past midnight
    By RayRay248 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-25-2021, 06:05 AM
  2. [SOLVED] #value being return in a formula in some cells while working in others
    By rjackson104 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-29-2013, 06:58 PM
  3. [SOLVED] Vlookup not working – incorrect return
    By pauldaddyadams in forum Excel General
    Replies: 2
    Last Post: 10-05-2012, 10:23 AM
  4. Match Single Cell and Return Row Macro Not Working
    By Steve0492 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2012, 03:44 PM
  5. macro to return to where user was working
    By hotmalepiyush in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-30-2008, 08:21 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