DATE FORMULA
Posted by liz on December 12, 2001 6:00 PM
Do you know how I can extract the month from a date eg. 24 May 1990 or if it is enter 24/5/1990 - I know I can use the Month(A1)function (if the date was in A1) but this gives me 5 but I would like it to give me May. How can I do this?
Hope you can help!! Thanking you.
Posted by Juan Pablo G. on December 12, 2001 6:11 PM
Two options:
=TEXT(A1,"mmm")
=A1 - DAY(A1) + 1
and custom format as "mmm"
Juan Pablo G.
Posted by Chris on December 13, 2001 11:31 AM
Data Formula - VBA equivilent of "TEXT" function?
What is the VBA equivilent of "=TEXT(A1,"mmm")"?
Posted by Jack in UK on December 22, 2001 5:26 PM
Re: Data Formula - VBA equivilent of "TEXT" function?
ActiveCell.FormulaR1C1 = "=TEXT(NOW(),""mmm"")"
Sorry it a bit late but works fine
Hope you see it
HTH
Jack in UK
