Hello
I need one word macro where what i need is we have invoices on word
where description says"for  Professional services rendered in
connection with the following for the year ended march 31, 2010

after running the macro i need following

as it is March 2010 which is still not completed so ended word should
get replace with the ending , basically it should compare the
date(march 31, 2010) on the description with the system date and
choose ended or ending depend on the description suppose if it is
December 2009 then it will be ended as December is already past and if
it is April 2010 it should be ending

Please help me !

Note always dte will be in the same format mentioned above

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Reply via email to