dear sir,
i want to get date in three different column like 23 in one column 12 in another column & 2011 in another column through formula if it is possible then please tell me the formula so that i used that formula.
Please treate it very urgent.........................
Thanks & Regards
Charitra Banerjee
9928277086
New Excel Forum
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
|
|
Unlocking the Mysteries of Excel
|
date function
2 posts
• Page 1 of 1
Re: date function
by Sisyphus » Fri Dec 23, 2011 2:37 am
Hi,
You can use the DAY(), MONTH() and YEAR() functions. Like ...
The above formula will return 12.
Does that help you?
You can use the DAY(), MONTH() and YEAR() functions. Like ...
- Code: Select all
=MONTH(Date)
The above formula will return 12.
Does that help you?
- 0
Have a great day!
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
- Sisyphus
- Former Moderator
- Posts: 4454
- Joined: Dec 7, 2011
- Location: Shanghai
- Reputation: 203
- Excel Version: 2010
2 posts
• Page 1 of 1
Return to General Excel Questions
Who is online
Users browsing this forum: No registered users and 254 guests