+ Reply to Thread
Results 1 to 4 of 4

Adding extra days to a deadline and accounting/compensating for them via a formula

  1. #1
    Registered User
    Join Date
    07-22-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    9

    Adding extra days to a deadline and accounting/compensating for them via a formula

    Hi all. I hope someone can help. I have been trying to work this out for quite some time now.

    I have a spreadsheet set up to work out deadlines for tasks to be met.

    The problem I am having, is that I want it to account for extra holidays/non-working dates and for it to add extra days on to compensate for the days lost through those extra non-working dates. I know I will need to input those dates to account for somewhere, but have no idea how to incorporate it into a formulas so that it works it for me.

    My current formulas is very simple and does work, but obviously does not account for the extra days, and although I could add them on myself, I would like to be in a position not to have to, as the amount of dates that I have to account for are far too many. Also, this sheet is to be accessed by quit a few people, so I need the data to be accurate due to the fact that the deadlines are legal deadline.

    This is my current formula: =IF(ISBLANK(B2),"",(B2 +40)

    Please can someone help? I would appreciate any help and advice.

    Many thanks

    Looloo

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Adding extra days to a deadline and accounting/compensating for them via a formula

    Hi,

    Without sight of the workbook it's difficult to be precise but assuming B2 is the calculation of the current deadline date, the approach I'd use is to create a list of non working dates and name this list say NonWDays, name the deadline date say "Deadline", and the start date of the task say "Start".
    Then use the following formula to identify the nonworking days between the start and deadline dates and add this number to your deadline
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    07-22-2011
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Adding extra days to a deadline and accounting/compensating for them via a formula

    Thank you Richard, I will give this a go, it sounds very complicated! lol

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Adding extra days to a deadline and accounting/compensating for them via a formula

    If you're more comfortable with seeing cell references in formulae then just substitute the names in the formula with the relevant cell address. It is more elegant and useful to use named ranges however.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. adding an extra bit in a formula
    By mowgli73 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-23-2014, 04:22 PM
  2. extra hours adding money for each extra hour worked FORMULA
    By cynthiamcastro in forum Excel General
    Replies: 3
    Last Post: 06-18-2012, 11:27 AM
  3. Calculating days left till deadline
    By sgp in forum Excel General
    Replies: 5
    Last Post: 11-08-2011, 11:56 AM
  4. Conversion of days into numbers and adding extra columns
    By nynamyna in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2011, 10:07 AM
  5. Number of days (mon,tue&thur) between today and deadline
    By D4B5T3R in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2010, 06:21 AM
  6. (IF formula) Adding extra functions
    By nacho12 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-23-2009, 04:17 AM
  7. [SOLVED] Adding an extra validation to this formula.
    By Mindie in forum Excel General
    Replies: 1
    Last Post: 03-07-2005, 08:06 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