Consulting

Results 1 to 4 of 4

Thread: Solved: Add NETWORKDAYS to a date

  1. 12-15-2006, 09:11 AM #1
    Philcjr
    Philcjr is offline
    VBAX Tutor Philcjr's Avatar
    Joined
    Jul 2005
    Location
    Bedminster, NJ
    Posts
    208
    Location

    Solved: Add NETWORKDAYS to a date

    How can I add 20 "NETWORKDAYS" to a given date?

    I have a beginng date
    I have number of working days (less weekends)
    I want to figure out the "date" after the working days are added to the beginning date

    I would like to do this with a formula not VBA.

    Thanks,
    Phil
    Reply With Quote Reply With Quote
  2. 12-15-2006, 09:55 AM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    =WORKDAY(A1,20)
    Reply With Quote Reply With Quote
  3. 12-15-2006, 10:24 AM #3
    Zack Barresse
    Zack Barresse is offline
    Site Admin
    Urban Myth
     VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    LOL! You gotta love the simplicity.

    Hope things are well for ya Phil. Been meaning to email you. Have a good holidays!!!
    Regards, Zack Barresse

    Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
    What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
    Reply With Quote Reply With Quote
  4. 12-15-2006, 03:12 PM #4
    Philcjr
    Philcjr is offline
    VBAX Tutor Philcjr's Avatar
    Joined
    Jul 2005
    Location
    Bedminster, NJ
    Posts
    208
    Location
    Thanks XLD... as usual you save the day

    Zack, I'll e-mail you soon... now, I am off on vacation.

    Phil
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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