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 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,
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 wrote:
> Hi Friends,
>
> Here I am sending One Query, pl Give the formula..
>
> Date : 31/03/2011 ( Format is dd/mm/ )
> Deduct : 6 (
You are welcome Nikhil..!!
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Wed, Jul 7, 2010 at 6:17 PM, Nikhil Shah wrote:
> Hi Dilip
>
> Thanks for sending me formula..I have apply this
Hi,
If original date is in A1:
=EOMONTH(A1,-6)
Regards - Dave.
Date: Wed, 7 Jul 2010 16:36:18 +0530
Subject: $$Excel-Macros$$ Query - How To Find out Month
From: nikhil201...@gmail.com
To: excel-macros@googlegroups.com
Hi Friends,
Here I am sending One Query, pl Give the formula..
Date : 31
Hi Nikhil,
Try below formula:-
=DATE(YEAR(C3),MONTH(C3)-6,DAY(C3))
Note:- Day portion of Date may vary as per the exact calculation, please
revert if you need 31 or 30 as the date every time.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmai
Hi Friends,
Here I am sending One Query, pl Give the formula..
Date : 31/03/2011 ( Format is dd/mm/ )
Deduct : 6 ( Months )
Answer Should be : 30/09/2010
Thanks
Nikhil Shah
--
--
Some important links for e
