to Display current month as text

  • Thread starter Thread starter jakol
  • Start date Start date
J

jakol

wats the formula to display the current month as a text (like February
instead of 02) thank you much
 
jakol

Are you sure you want it to be "Text" or just look like Text.

You can Format>Cells>Custom "mmmm" to show February only but still retain the
actual date.

Gord Dibben Excel MVP
 
thanks for the replies..wat i did is format the cell to custom,as you
said to"mmm" and give it a formula of TODAY() to dsplay the current
month, i print this form evry month so i dont have to change the month
every time, wat im trying to figure out now is how to automatically
display the days beginning from 23 of the month(in individual
cells)...e.g: 23 24 25 26 and so on. with relevance to currenth month
ex.for feb. last day is 29. im losing my hair trying to fig this out, i
hope you can help me, it will make my job more easy...tahnk you again.
 
Hi
if your date (formated as month) is stored in A1 and the days starting
at the 23th are stored in B1 - Bn enter the following formula in B1
=DATE(YEAR(A1),MONTH(A1),ROW()+22)
copy down
 
If you simply want it to return whatever month it
currently is use =TEXT(TODAY(),"mmmm") in whatever cell
you wish the date to appear.
 
frank
ur formula works but created a problem, it display the days of current
month starting from day 23 to day 22 of next month, but some months
will have 30, 31 or 28 days so the last cells will cont to show days 23
or 24 of the next month, i hope u get my point, is there a formula that
will cancell the next cells if the preceding cell =to day 22? thank u
in advance.
 
Hi
try the following in B1
=IF(DATE(YEAR(A1),MONTH(A1),ROW()+22)>DATE(YEAR(A1),MONTH(A1)+1,22),"",
DATE(YEAR(A1),MONTH(A1),ROW()+22))
 
Back
Top