Results 1 to 25 of 25

Date Calculation + 5 / 20 working days depending on what is within a cell

Threaded View

  1. 01-07-2021, 12:16 PM #1
    digbee
    digbee is offline
    Registered User
    Join Date
    08-08-2019
    Location
    Scotland
    MS-Off Ver
    2019
    Posts
    51

    Date Calculation + 5 / 20 working days depending on what is within a cell

    Hi Guys,

    Looking for your help again.

    In column 5 I have a formula that calculates the 5 working day deadline based from the date inputted into column b.

    However I am now being asked to change this so that.

    Column F calculates from the date in Column B either 5 working day if column d states Stage 1 or 20 working day if Column D says Stage 2.

    Can anyone help?

    Thank you so much.

    Jodie
    Last edited by digbee; 01-07-2021 at 12:19 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF Statement with Multi-Criteria Statement inside a Data Validation List
    By dharvey1978 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2020, 09:10 PM
  2. [SOLVED] If statement to select data - nested statement - assistance
    By petitesouris in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-29-2015, 09:55 PM
  3. compile error expected line number statement end statement
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2014, 10:12 AM
  4. VBA Compile Error : line number or label or statement or end of statement
    By excellearner121 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2013, 06:41 PM
  5. [SOLVED] Convert If statement with cell row reference calculations to vlookup statement
    By excyclist in forum Excel General
    Replies: 4
    Last Post: 06-01-2012, 10:05 AM
  6. VBA- Compile Error, Expected: line number or label or statement or end of statement
    By RLK7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2012, 05:33 PM
  7. [SOLVED] Utilize a Select Case Statement in Target Intersect Statement
    By max57 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2009, 08:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1