Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    If Statement (Excel 2003)

    I need some help with an IF statement.

    I need, in Column C, if possible, an addition to my formula, that would increase by 1 day if the result turned out to be a holiday or Sunday. Is this something that I need to break apart into smaller formulas? I have a list of holidays (3 total) on the list tab.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: If Statement (Excel 2003)

    I don't understand the purpose of columns A, B and C, but if you want to create a list of working days in 2008 (i.e. exclude weekend days and holidays):
    - Enter 12/31/2007 in a cell, I'll use D1 as example. You can make the font color white if you want to hide this date.
    - Enter the following formula in the cell below (D2 in the example):

    =WORKDAY(D1,1,Holiday)

    - Fill down as far as needed.

Posting Permissions

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