LinkBack URL
About LinkBacks
Hi,
I was trying this month() formula in G2 but instead of showing the month its showing January,please advice.
Hi,
I was trying this month() formula in G2 but instead of showing the month its showing January,please advice.
Last edited by arnab0711; 08-20-2012 at 03:09 AM.
Try to format (Ctrl-1 short key) this cell as general or number (current format is date)
Quang PT
Month() returns the Month of a date as an integer. You have entered an integer not a date
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hi,
I have to show the month,hence I used text() function but still it is showing as january,please advice.
Ηι
Do you mean something like this?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
how about
=TEXT(DATE(2000,MONTH(H2),1),"mmmm")
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thanks for the star.
Also you're welcome from all of us. We had all learned from your query. thanks.
I you have time can you now mark this thread solved.
thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks