I need a formula that will tell me the month and only the month in the smallest amount of numbers as possible. Meaning if the date is 3/10/2010 the formula should display 3 and if the date is 10/10/2010 the value would be 10. Also I need to be able to extract the day and year. So in total there should be three formulas:
1 to tell me the month
1 to tell me the day of the month
and 1 to tell me to year
If anyone knows how to do this I'd be very grateful. I thought of using Left(A1,1) or something to that affect but since not all months are the same length and not all days are the same length that would not work.
Bookmarks