Hi

You can use the below formulae for calculation as required:

=EDATE("31-mar-2011","-6")

Regards
Rajender Soni

On Jul 7, 5:21 pm, Avinash Daga <avinashdag...@gmail.com> wrote:
> Assuming your current date is in a1 cell....
>
> =date(year(a1),month(a1)-6,day(a1))
>
> Please let me know,if this works
>
>
>
>
>
> On Wed, Jul 7, 2010 at 4:06 AM, Nikhil Shah <nikhil201...@gmail.com> wrote:
> > Hi Friends,
>
> > Here I am sending One Query, pl Give the formula..
>
> > Date : 31/03/2011 ( Format is dd/mm/yyyy )
> > Deduct : 6 ( Months )
>
> > Answer Should be : 30/09/2010....
>
> > Thanks
> > Nikhil Shah
>
> > --
> > ---------------------------------------------------------------------------­-------
> > 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 athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 7000 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
>
> --
> Thanks and Regards,
> Avinash Daga
> Sr. Analyst,CMG
> Mortgage Industry Advisory Corporation (MIAC)+91-963-234-8190- Hide quoted 
> text -
>
> - Show quoted text -

-- 
----------------------------------------------------------------------------------
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

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

We reach over 7000 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