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.
