**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need a formula that looks up if the date (which looks like "8/1/2018 8:05:36 AM") in Column "C" contains year 2018. And then populates "2018" in Column D, if the date does not contain "2018" then enter False in Column D.

Solved by F. H. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
10/04/2018 - 12:32

2016

Excelchat Expert
10/04/2018 - 12:32

Welcome to Got It Pro

Excelchat Expert
10/04/2018 - 12:34

You need to check the year in column C and return in column D. Right?

Excelchat Expert
10/04/2018 - 12:35

Are you with me?

Excelchat Expert
10/04/2018 - 12:36

Suppose, you have date and time entry in cell C2 as per format mention in problem description

Excelchat Expert
10/04/2018 - 12:38

And you want to check if YEAR in date is 2018, then return 2018, else FALSE in column D in next cell

Excelchat Expert
10/04/2018 - 12:39

You will use following IF statement in cell D2

Excelchat Expert
10/04/2018 - 12:39

=IF(YEAR(C2)=2018,YEAR(C2),FALSE)

Excelchat Expert
10/04/2018 - 12:41

As your date input in cell C2 contains year 2018, the formula in cell D2 will return "2018"

Excelchat Expert
10/04/2018 - 12:43

And if you change the date as "8/1/2017 8:05:36 AM", then it will return FALSE in cell D2

Excelchat Expert
10/04/2018 - 12:45

You can see the formula output in column D

Excelchat Expert
10/04/2018 - 12:46

Here is link of your solution for your review

Excelchat Expert
10/04/2018 - 12:46

https://docs.google.com/spreadsheets/d/10txk34c76zRQg3XbVUr_HpcDT7Va25GdWpRjiqdNQ1E/edit?usp=sharing

Excelchat Expert
10/04/2018 - 12:47

Session time is expiring after in next 4 minutes

Excelchat Expert
10/04/2018 - 12:47

Please respond and confirm the solution as per your problem description

Excelchat Expert
10/04/2018 - 12:51

Session is about to end

Excelchat Expert
10/04/2018 - 12:51

Thanks for using Got It Pro

Excelchat Expert
10/04/2018 - 12:51

Have a nice day ahead :)

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*