Separating Dates Using IF Function [Closed]

Question

Separating Dates Using IF Function [Closed]

Report

ajohnson - Jan 6, 2017 at 12:41 PM
Mazzaropi

Posts: 1914
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: April 7, 2021

- Jan 6, 2017 at 01:00 PM

Hello,

I'm trying to set up an IF function, I believe...I have a spreadsheet that lists dates back to 2013 as MM/DD/YYYY. I'm trying to create a formula that would read that date (specifically the year) and then assign a number to it. For example 2014 =1, 2015 = 2, etc. I'm new to the intricacies of Excel and don't know what I'm doing.

Separating Dates Using IF Function
How do you do an if function with dates? - How-To - Excel
Excel If Function over a range of dates - How-To - Excel
Difference between two dates : Datedif Function - How-To - Excel
IF functions with dates ✓ - Forum - Excel
Some help needed about IF function with dates ✓ - Forum - Excel

1 reply

Ask a question

Mazzaropi · Answer 1 · 2017-01-06T13:00:27-0500

Answer 1 / 1

Mazzaropi

Posts: 1914
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: April 7, 2021

142
Jan 6, 2017 at 01:00 PM

ajohnson, Good afternoon.

Excel have a lot of possibilities to do the same job always.

As you said that the older year is 2013, Try to do:

Supposing:

A1 --> DATE

B1 --> =IF(YEAR(A1)=2013,1, IF(YEAR(A1)=2014,2, IF(YEAR(A1)=2015,3, IF(YEAR(A1)=2016,4, IF(YEAR(A1)=2017,5,"")))))

OR

B1 --> =YEAR(A1)-2012

Remember to format B column as number.

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Separating Dates Using IF Function [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!