<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/'><id>tag:blogger.com,1999:blog-2509167754737584590.post1063086895511306071..comments</id><updated>2012-01-17T23:00:11.200+05:30</updated><category term='Excel Addins'/><category term='countif two criteria'/><category term='Hide cell contents before printing'/><category term='Sum Top 5 values in Unsorted Range'/><category term='Forcing users to use updated version'/><category term='Macros in Excel'/><category term='countif array'/><category term='PMT Function in Excel'/><category term='Test if workbook is open or not'/><category term='Formating Numbers in Excel'/><category term='Symbol Check Mark'/><category term='Disable Cut Copy Paste in Excel'/><category term='Pivot Tables'/><category term='Range Name Excel'/><category term='calculating age'/><category term='Custom Functions'/><category term='Excel Vlookup Function'/><category term='subtotal function excel'/><category term='multiple countif'/><category term='Deploy Macros Found Elsewhere'/><category term='Get Number From String'/><category term='countif with multiple criteria'/><category term='Send email with VBA'/><category term='Excel Currency Format'/><category term='Excel Macros'/><category term='Excel Formulas'/><category term='sumif multiple'/><category term='subtotal in excel'/><category term='Auto Open Macro'/><category term='Extract Number From String'/><category term='Automating Tasks in Excel'/><category term='Adding non printing information to your worksheet'/><category term='Find Duplicate'/><category term='Hardware Locking for Excel Workbook'/><category term='Excel Date Picker'/><category term='Profit and Loss report using Pivot Tables'/><category term='Excel Last Row'/><category term='Find Last Row'/><category term='Spell Currency'/><category term='Extract Number From Text'/><category term='EMI Calculator'/><category term='Macro Last Row'/><category term='File Open'/><category term='countif multiple conditions'/><category term='Excel Pop up Calendar'/><category term='Wingdings Check Mark with double click'/><category term='Sorting Dates by Birthday'/><category term='Disable right click menu'/><category term='Working with date function'/><category term='excel subtotals'/><category term='Excel Kay Board Shortcuts'/><category term='Defined Names'/><category term='Excel Closest Match'/><category term='Indian Style Comma Separation for numbers'/><category term='Converting Text to date'/><category term='Convert Numbers to Words'/><category term='Working with Data Range'/><category term='Show Developer Tab'/><category term='Logging User Activity'/><category term='Numbers to Text'/><category term='VBA Last Row'/><category term='Countif Multiple Criteria'/><category term='Email Address Extract'/><category term='Add Spin Buttons ActiveX Controls'/><category term='Visual Basic Grammar'/><category term='Formating Cells in Excel'/><category term='Making EMI Calculator'/><category term='Excel Number Format'/><category term='sumif multiple criteria'/><category term='subtotals in excel'/><category term='multiple sumif criteria'/><category term='Remove Duplicate'/><category term='Learn Excel VBA'/><category term='Forcing users to Enable Macros'/><category term='subtotal excel'/><category term='Text To Numbers'/><category term='SpellCurr()'/><title type='text'>Comments on Yogesh Gupta's Excel Tips: Excel Sort Dates by Birthday</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://www.yogeshguptaonline.com/feeds/1063086895511306071/comments/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2509167754737584590/1063086895511306071/comments/default'/><link rel='alternate' type='text/html' href='http://www.yogeshguptaonline.com/2010/02/excel-sort-dates-by-birthday.html'/><author><name>Yogesh Gupta</name><uri>http://www.blogger.com/profile/08246342663404873564</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='http://1.bp.blogspot.com/_3QrPv-CwOcc/StCm3VNBEOI/AAAAAAAAAIg/4ahMTa1Ps5c/S220/Yogesh.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>3</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-2509167754737584590.post-7422949022140030359</id><published>2012-01-17T23:00:11.200+05:30</published><updated>2012-01-17T23:00:11.200+05:30</updated><title type='text'>Hi,
I read the above post,but didn&amp;#39;t understan...</title><content type='html'>Hi,&lt;br /&gt;I read the above post,but didn&amp;#39;t understand much about the sort key column...I have to sort the entries according to the date &amp;amp; month and not according to the year..so could you please help me?&lt;br /&gt;here&amp;#39;s my email id if required- amitfunforlife@gmail.com&lt;br /&gt;thanking in advance,&lt;br /&gt;Amit.</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2509167754737584590/1063086895511306071/comments/default/7422949022140030359'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2509167754737584590/1063086895511306071/comments/default/7422949022140030359'/><link rel='alternate' type='text/html' href='http://www.yogeshguptaonline.com/2010/02/excel-sort-dates-by-birthday.html?showComment=1326821411200#c7422949022140030359' title=''/><author><name>amit</name><uri>http://www.blogger.com/profile/03066939336128163346</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://www.yogeshguptaonline.com/2010/02/excel-sort-dates-by-birthday.html' ref='tag:blogger.com,1999:blog-2509167754737584590.post-1063086895511306071' source='http://www.blogger.com/feeds/2509167754737584590/posts/default/1063086895511306071' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-454849052'/></entry><entry><id>tag:blogger.com,1999:blog-2509167754737584590.post-6236123902085919953</id><published>2010-03-13T07:51:17.623+05:30</published><updated>2010-03-13T07:51:17.623+05:30</updated><title type='text'>Hi D S Raj

Such conversion is possible through cu...</title><content type='html'>Hi D S Raj&lt;br /&gt;&lt;br /&gt;Such conversion is possible through custom function only. Date formatting can not handle year conversion into words.&lt;br /&gt;&lt;br /&gt;wtw why do you need such conversion, I have not seen any one using dates like this.&lt;br /&gt;&lt;br /&gt;Regards&lt;br /&gt;Yogesh Gupta</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2509167754737584590/1063086895511306071/comments/default/6236123902085919953'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2509167754737584590/1063086895511306071/comments/default/6236123902085919953'/><link rel='alternate' type='text/html' href='http://www.yogeshguptaonline.com/2010/02/excel-sort-dates-by-birthday.html?showComment=1268446877623#c6236123902085919953' title=''/><author><name>Yogesh Gupta</name><uri>http://www.blogger.com/profile/08246342663404873564</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='http://1.bp.blogspot.com/_3QrPv-CwOcc/StCm3VNBEOI/AAAAAAAAAIg/4ahMTa1Ps5c/S220/Yogesh.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://www.yogeshguptaonline.com/2010/02/excel-sort-dates-by-birthday.html' ref='tag:blogger.com,1999:blog-2509167754737584590.post-1063086895511306071' source='http://www.blogger.com/feeds/2509167754737584590/posts/default/1063086895511306071' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-1113289490'/></entry><entry><id>tag:blogger.com,1999:blog-2509167754737584590.post-529438919630094954</id><published>2010-03-12T21:55:35.815+05:30</published><updated>2010-03-12T21:55:35.815+05:30</updated><title type='text'>Sir, 
Can you help me in converting date into word...</title><content type='html'>Sir, &lt;br /&gt;Can you help me in converting date into words&lt;br /&gt;such as 05.04.1995 into Fifth, April, Nineteen Ninety five</content><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2509167754737584590/1063086895511306071/comments/default/529438919630094954'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2509167754737584590/1063086895511306071/comments/default/529438919630094954'/><link rel='alternate' type='text/html' href='http://www.yogeshguptaonline.com/2010/02/excel-sort-dates-by-birthday.html?showComment=1268411135815#c529438919630094954' title=''/><author><name>D S Raj</name><uri>http://www.blogger.com/profile/12051483512445984960</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='http://www.yogeshguptaonline.com/2010/02/excel-sort-dates-by-birthday.html' ref='tag:blogger.com,1999:blog-2509167754737584590.post-1063086895511306071' source='http://www.blogger.com/feeds/2509167754737584590/posts/default/1063086895511306071' type='text/html'/><gd:extendedProperty xmlns:gd='http://schemas.google.com/g/2005' name='blogger.itemClass' value='pid-313367861'/></entry></feed>
