Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-19-2019, 02:37 AM
elysse77 elysse77 is offline Windows 10 Office 2019
Banned
 
Join Date: Apr 2019
Posts: 1
elysse77 is on a distinguished road
Default Need help with if/then formulas


Hello everyone,

I’m a novice at Excel and just recently found out how much easier it is to organize data and have Excel do all the “heavy lifting” for me at work.

What I pretty much want to do is have Excel generate a date after it references two different columns. For example, in one column I have dates, and in the second column I have text.

Column 1 has dates. Column 2 has text. So if I type in a specific text in the second column, I want it to generate the date 45 days from the first column in a third column. A different text would generate 45 days in the third column & 60 days in the fourth column.

Example 1: First column = 1 April 2019 Second column = ABC Third column = 16 May 2019 (automatically generates 45 days from Column 1 by Excel)

Example 2: First column = 1 April 2019 Second column = DEF Third Column = 16 May 2019 (automatically generates 45 days from Column 1 by Excel) Fourth column = 31 May 2019 (also automatically generates 60 days from Column 1 by Excel)

Thank you!
Reply With Quote
  #2  
Old 04-19-2019, 06:59 AM
p45cal p45cal is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 253
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
Default

In cell C2:
Code:
=IF(OR(B2="ABC",B2="DEF"),A2+45,"")
In cell D2:
Code:
=IF(B2="DEF",A2+60,"")
copy C2:D2 down.
You may need to format the cells with the formulae in as dates.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas help Grizz1955 Project 0 08-22-2017 05:26 AM
help with formulas ferrarifx Excel 2 11-16-2016 12:04 PM
Help with IF or ELSE Formulas tsaladyga Excel 4 07-23-2014 09:04 AM
Need help with formulas please paul_pearson Excel 0 03-20-2013 06:51 AM
IF Formulas mizzamzz Excel 1 07-08-2010 02:32 AM


All times are GMT -7. The time now is 11:06 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft