Hi,
I'm importing information from Outlook and one of the columns I need has the date. However, no matter how I format the column with the Date info, Outlook formats some of the dates as Mon 2/29. I'm trying to pull the date out, so I'm using the following formula
=MID(C2,5,4)
That is returning 2/29. However, the remainder of the dates in the column show up as (ie) 2/27/16.
I'm looking for a formula that will just return the number of the month for the whole column. How do I add an IF statement that utilizes my MID statement?
Bookmarks