I have to convert a full date, to just show year and month.
Column A has date the 4/27/2017 , I need a formula in Column B to show only the year (2017) and column C to show only the month (April)
Thank you, LaDonna
I have to convert a full date, to just show year and month.
Column A has date the 4/27/2017 , I need a formula in Column B to show only the year (2017) and column C to show only the month (April)
Thank you, LaDonna
Column B:
=Year(A2)
Column C:
=TEXT(A2, "mmmm")
Thank you !!!
Another question, how do I prevent 1900 from showing in the blank cells?
You use IF function.
=IF(A2="","",YEAR(A2))
Ohhh.. got it.. THANK YOU !!
You are welcome and thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks