How can i show date in this form (month,last date of that month, Year)?
09302014
08312014
10312014
How can i show date in this form (month,last date of that month, Year)?
09302014
08312014
10312014
Click on (*), if you agree.
Can anyone reply to this email?
Hi,
you could use a customized format
mmddyyy
Hope it helps
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
I want to get last month date of every previous month.
Is that date formatted as text? If yes maybe:
=VALUE(MID(A1,3,2))&", "&EOMONTH(VALUE(LEFT(A1,2)),0)&", "&VALUE(RIGHT(A1,4))
You can use the following formula to create the date for the last day of the month.
Cell A1 contains a date.![]()
Please Login or Register to view this content.
If A1 contains 2014-10-24 then the formula will return the date 2014-10-31.
Use customer number formatting to create the date format you wish to use. For more information see http://office.microsoft.com/en-us/ex...010342372.aspx.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks