Is there a formula that will return only the month from a date?
Use formula = month(A1)
"birdgirl31" wrote:
I have a column with dates. I want to put a cell with a formula beside each
date that will return the month. I know I can do this with formatting but I
want to use the "month" column in a pivot that will let me sort my data by
month. When I just return the date value and change the formatting to show as
month, the pivot still reads the "month" cells as a day.
|