+ Reply to Thread
Results 1 to 4 of 4

Dropdown to add days to today's date

  1. #1
    Registered User
    Join Date
    03-09-2014
    Location
    North Carolina
    MS-Off Ver
    Excel 2013
    Posts
    24

    Dropdown to add days to today's date

    Hello,
    I am looking to have a dropdown list (1-30 days) to add the selected number of days to today's date. The number selected in cell B2 adds that number of days to today's date in C2. Any help is greatly appreciated!

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: Dropdown to add days to today's date

    Put this formula in C2

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    03-09-2014
    Location
    North Carolina
    MS-Off Ver
    Excel 2013
    Posts
    24

    Re: Dropdown to add days to today's date

    Thank you AlphaFrog, Again! How would I add if B2 is blank, then C2 is blank. I played around with <>"" but could not get it to work.
    Thanks!

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: Dropdown to add days to today's date

    Try this...

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. Calculate number of days between invoice date and today's date
    By JHerrick in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-30-2020, 03:53 PM
  2. [SOLVED] Macros for: If Today's Date minus other date is greater than certain amount of days Then
    By lottidotti in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-24-2012, 04:46 PM
  3. Re: how to work out how many days from date to today
    By Melville in forum Excel General
    Replies: 2
    Last Post: 07-05-2010, 07:21 PM
  4. Counting down from a date when it is 150 days from today
    By HeatherBelle79 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-17-2008, 11:43 AM
  5. create a macro to alert me if today's date is within 5 days of expected delivery date
    By ashmcclure in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 09-25-2008, 05:51 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