• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

add 1 year to specified cell as value in if formula

Toni

New Member
My file has start dates, with an if formula that says =IF(D3<42430,"March 2017",D3) but I need the "else" result to be D3 plus one year. See potion of file below:

Name Eligible for Increase
(SPL) 100 John Street March 2017
(SPL) 100 John Street March 2017
(SPL) 100 John Street March 2017
(SPL) Fla Police/Firefighters March 2017
(SPL) NY POLICE/FIREFTRS March 2017
(SPL) NY POLICE/FIREFTRS March 2017
(SPL) SF POLICE/FIREFTRS March 2017
(SPL) SF POLICE/FIREFTRS March 2017
(SPL) TAKE TWO INTRACTV March 2017
(SPL) TAKE TWO INTRACTV March 2017
1199 SEIU FUNDS - MBRS (CEP) March 2017
1199 SEIU FUNDS - MBRS (CEP) March 2017
1199 SEIU FUNDS - MBRS (CEP) March 2017
1511 Treat Blvd Business Center (CEP) 10/17/2016
1511 Treat Blvd Business Center (CEP) 10/17/2016
1511 Treat Blvd Business Center (CEP) 10/17/2016

Instead of returning value of 10/17/16, should return value of 10/17/17
 
if you post sample file its very clear idea.
My file has start dates, with an if formula that says =IF(D3<42430,"March 2017",D3) but I need the "else" result to be D3 plus one year. See potion of file below:

Name Eligible for Increase
(SPL) 100 John Street March 2017
(SPL) 100 John Street March 2017
(SPL) 100 John Street March 2017
(SPL) Fla Police/Firefighters March 2017
(SPL) NY POLICE/FIREFTRS March 2017
(SPL) NY POLICE/FIREFTRS March 2017
(SPL) SF POLICE/FIREFTRS March 2017
(SPL) SF POLICE/FIREFTRS March 2017
(SPL) TAKE TWO INTRACTV March 2017
(SPL) TAKE TWO INTRACTV March 2017
1199 SEIU FUNDS - MBRS (CEP) March 2017
1199 SEIU FUNDS - MBRS (CEP) March 2017
1199 SEIU FUNDS - MBRS (CEP) March 2017
1511 Treat Blvd Business Center (CEP) 10/17/2016
1511 Treat Blvd Business Center (CEP) 10/17/2016
1511 Treat Blvd Business Center (CEP) 10/17/2016

Instead of returning value of 10/17/16, should return value of 10/17/17
if you post sample file its very clear idea.
 

Attachments

  • Book2.xlsx
    8.5 KB · Views: 2
  • Book2.xlsx
    8.5 KB · Views: 0
  • Book2.xlsx
    8.5 KB · Views: 1
I've uploaded the file, I'm sure the answer is very easy, I just can't get the proper format!
 
Back
Top