+ Reply to Thread
Results 1 to 8 of 8

Auto calculate date

  1. #1
    Registered User
    Join Date
    04-12-2012
    Location
    Jackson, TN
    MS-Off Ver
    Excel 2003
    Posts
    9

    Auto calculate date

    Okay I am trying to create a spreadsheet that will automatically populate some due date information. In C3 is the date received, D3 is a drop down box with the option of priority 1, priority 2, and priority 3. I need E3 to automatically populate the date it is due by based on the initial date and what s selected in D3, priority 1 needs to equal original date plus 1, priority 2 equals the original date plus 2 days, the priority 3 is plus three days, but weekend days are excluded in that calculation. I hope this makes sense

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Auto calculate date

    will column D be the text string "Priority 1","Priority 2" ect, or the numbers 1,2,3?
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

  3. #3
    Registered User
    Join Date
    04-12-2012
    Location
    Jackson, TN
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Auto calculate date

    It will be priority 1, priority 2, etc

  4. #4
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Auto calculate date

    you can use this:

    =C3+right(D3,1)

  5. #5
    Registered User
    Join Date
    04-12-2012
    Location
    Jackson, TN
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Auto calculate date

    That didn't work?

  6. #6
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,719

    Re: Auto calculate date

    Try using WORKDAY function (you need to enable Analysis ToolPak in Excel 2003), i.e. use this formula in E3

    =WORKDAY(C3,RIGHT(D3))

    format E3 in required date format
    Audere est facere

  7. #7
    Registered User
    Join Date
    04-12-2012
    Location
    Jackson, TN
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Auto calculate date

    Okay I tried that, and it does solve the problem of eliminating the weekends, but I only need it do that if "Priority 3" is selected in the drop down box, if it's 1 or 2 then it doesn't matter if it's a weekend or not.

  8. #8
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Auto calculate date

    Try this

    =IF(RIGHT(D3,1)+0=3,WORKDAY(C3,RIGHT(D3)),C3+RIGHT(D3,1))

+ Reply to Thread

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