+ Reply to Thread
Results 1 to 4 of 4

Calculating a future date based on a specific cell date

  1. #1
    Registered User
    Join Date
    04-30-2015
    Location
    Portsmouth, England
    MS-Off Ver
    2010
    Posts
    10

    Calculating a future date based on a specific cell date

    Hi All

    I need a little bit of help please, if you don'r mind.

    I am using a formula in E2 to calculate 1 year and 1 day from the date entered in C2:

    =DATE(YEAR(C2)+1,MONTH(C2),DAY(C2)+1)

    My problem is I need to combine an if(isblank function to the function above so that when there is no date in the subsequent cells in column C nothing appears in the corresponding cell in column E all be it the formula will be there.

    Hope this makes sense

    Any help would be appreciated

    Teuchter

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Calculating a future date based on a specific cell date

    Hi and welcome.
    Is this what you're after

    =if(C2="","",DATE(YEAR(C2)+1,MONTH(C2),DAY(C2)+1))

    If not atach your worksheet s o we can see an example
    Happy with my advice? Click on the * reputation button below

  3. #3
    Registered User
    Join Date
    04-30-2015
    Location
    Portsmouth, England
    MS-Off Ver
    2010
    Posts
    10

    Re: Calculating a future date based on a specific cell date

    Crooza

    Perfect! Thank you for your help, it is greatly appreciated.

  4. #4
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Calculating a future date based on a specific cell date

    You're welcome. Merry Christmas

+ 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. [SOLVED] Formula for calculating a new date based on an existing date and other cell criteria
    By scsuflyboy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-27-2013, 09:49 AM
  2. Calculating a future date based on a 360 day calendar
    By ertavis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-29-2012, 07:43 PM
  3. Calculating multiple future dates based on one completion date
    By Staceyd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2010, 03:38 PM
  4. Insert a future date based on a number in another cell
    By LongShanks in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-10-2010, 10:48 AM
  5. Calculating future date
    By Jmntgmry18 in forum Excel General
    Replies: 1
    Last Post: 09-11-2009, 08:07 AM
  6. Calculating a Date for the Future
    By Niki6 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-19-2005, 06:49 PM
  7. Replies: 2
    Last Post: 02-10-2005, 04:06 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