Results 1 to 4 of 4

Adding 30 working days to a date

Threaded View

Dawn V Adding 30 working days to a... 06-16-2008, 08:01 AM
NBVC Try the Workday() function..... 06-16-2008, 08:08 AM
Dawn V NBVC... Thank you VERY... 06-16-2008, 08:17 AM
NBVC You are welcome... and Thank... 06-16-2008, 08:19 AM
  1. #1
    Registered User
    Join Date
    02-25-2008
    Location
    Rhode Island
    Posts
    56

    Question Adding 30 working days to a date

    Good morning!

    I'm trying to add 30 working days to a formula. I tried a simple formula and it wasn't working. I tried =weekday(y8,30) and the result came back #NUM!

    I'm trying to:

    y8 has a date reference & I need to add 30 working days to that date in
    cell z8 as a due date.

    At the same time, I would like cell z8 to remain blank until the y8 date has been entered.

    Can someone please help me figure out the formula?

    Thanks,
    Dawn
    Last edited by Dawn V; 06-16-2008 at 08:04 AM.

Thread Information

Users Browsing this Thread

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

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