Results 1 to 12 of 12

IFS to add 5 working days or 7 working days to date dependant on other cell data

Threaded View

  1. #1
    Registered User
    Join Date
    01-11-2024
    Location
    London
    MS-Off Ver
    Mac 365 Version 16.78.3
    Posts
    4

    Question IFS to add 5 working days or 7 working days to date dependant on other cell data

    Hi all,

    Grateful for some advice on a function I'm struggling to conquer.

    I have Cell A2 displaying a reference number (this starts with either MCxxxx or TOxxxx). In G2 a received date is entered and in H2 I need the function to add either 5 Working days to the G2 date if "MC' has been entered into A2. Or add 7 working days to the G2 date if "TO" has been entered into A2. If there is no reference in A2 or no date entered in G2 then no result shown in H2....

    Hope that makes sense!

    Hope someone can offer a solution. Struggling with the IF/OR function I'm currently trialing.

    Than
    Last edited by AliGW; 01-11-2024 at 10:48 AM. Reason: Irrelevant part of title removed.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 07-14-2022, 05:29 AM
  2. Replies: 2
    Last Post: 12-05-2018, 01:46 AM
  3. [SOLVED] Formula to calculate working days and calendar days per month-year ?
    By donny007 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-05-2018, 06:23 PM
  4. [SOLVED] Formula to add days to a date is not working - spreadsheet uploaded.
    By apmi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-21-2014, 04:57 PM
  5. Previous working days date (Mon-Fri working week).
    By intothewild in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2011, 01:00 PM
  6. Formula for adding 7 working days to a date
    By MissLeigh in forum Excel General
    Replies: 4
    Last Post: 07-14-2011, 03:53 AM
  7. formula to get date Today-1 (Only working days)
    By Chetan Chauhan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-02-2010, 07:14 AM

Tags for this Thread

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