Can you change a date into text?
For example,
A1 is 02/18/10....and I want A2 to say "Feb" or even "1" would be helpful.
Thanks,
Can you change a date into text?
For example,
A1 is 02/18/10....and I want A2 to say "Feb" or even "1" would be helpful.
Thanks,
If you have a date in A1 you can custom format the cell as "mmm" to show Feb or "mmmm" to show February.
If you want the result in another cell you can use TEXT function, e.g.
=TEXT(A1,"mmm")
If you want the month number use MONTH function, i.e.
=MONTH(A1)
[or with formatting format date cell as just m]
Audere est facere
If in A1 it says 2/18/11 and in b2 you put in the formula =month(a1) it would return a 2, which is the month of the date in the reference cell.
Hope that helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks