Hi, I don't think you need a formula. Would simply changing the cell
format work? If so, just go to Format Cells Number Custom and
enter "mmmm yyyy" (w/o quotes)
If you're looking for VBA, there's several ways to do that i.e.
******
With .Cells(1, 1)
'.Value = DATE
'.FormulaR1C1 = "=TODAY()" 'inserts formula for
today
..Formula = .Value 'takes the formula above &
converts to value
'.NumberFormat = "ddd, * d mmm yy" 'returns Fri,
25 Nov 05 (*=justified alignment)
..NumberFormat = "mmmm yyyy" 'returns November 2005
..NumberFormat = "mmm yyyy" 'returns Nov 2005
End With
HTH
--
AH·C
------------------------------------------------------------------------
AH·C's Profile:
http://www.excelforum.com/member.php...o&userid=29108
View this thread:
http://www.excelforum.com/showthread...hreadid=488295