The trick here is to understand that Excel doesn't know anything about "dates" and "time". What it does is take the number of days since 1/1/1900 and INTERPRETS it as days and fraction of days. So.. 10/11/2010 @ 6:37pm is actually 40462 days since 1/1/1900 and .7756944444 of another day, or 40462.7756944444
Now, from 10/11/2010 to 11/11/2010 is 31 days. so, taking 10/11/2010 6:37pm + 31 = 11/11/2010 @ 6:37pm (or using a formula like =A2 + 31) to figure out how to do this for ANY month is a bit trickier... Paul ----- Original Message ---- > From: renuka chari <jva.ch...@gmail.com> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Mon, October 11, 2010 11:20:37 AM > Subject: $$Excel-Macros$$ good evening to all experts > > hi excel experts i have a small problem > > MY DATE AND TIME FORMAT IS "mm/dd/yyyy hh:mm am/pm" > I WANT > TO CHANGE COL: A CHANGED IN TO COL:A" > ===================================== > col:a col:a > ===================================== > > 10/11/2010 18:37 11/11/2010 18:37 > 10/11/2010 18:30 11/11/2010 18:30 > 10/11/2010 18:40 11/11/2010 18:40 > 10/11/2010 18:50 11/11/2010 18:50 > 10/11/2010 18:23 11/11/2010 18:23 > 10/11/2010 18:10 11/11/2010 18:10 > 10/11/2010 18:09 ====> 11/11/2010 18:09 > 10/11/2010 18:07 11/11/2010 18:07 > 10/11/2010 18:01 11/11/2010 18:01 > 10/11/2010 17:37 11/11/2010 17:37 > 10/11/2010 18:33 11/11/2010 18:33 > 10/11/2010 17:03 11/11/2010 17:03 > 10/11/2010 21:37 11/11/2010 21:37 > 10/11/2010 19:37 11/11/2010 19:37 > > i want change month only > thanks in advance > > -- >---------------------------------------------------------------------------------- >- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts