hi,
the betterr is
=DATE(YEAR(C4),MONTH(C4)+1,5)
because he wants 'next month' 5th.
R.Karunanithi
--- On Thu, 7/7/11, ashish koul wrote:
From: ashish koul
Subject: Re: $$Excel-Macros$$ help regarding date formula
To: excel-macros@googlegroups.com
Date: Thursday, July 7, 2011
Hi,
u use this
=DATE(YEAR(C4),MONTH(C4)+1,5)and drag the fill handle down till c4 is not
blank.
u will get what u want.
R.Karunanithi.
--- On Thu, 7/7/11, L.K. Modi wrote:
From: L.K. Modi
Subject: $$Excel-Macros$$ help regarding date formula
To: excel-macros@googlegroups.com
Date: Th
*ok sir
*Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Jul 7, 2011 at 11:44 AM, L.K. Modi wrote:
> THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS
>
>
> REGARDS
> LKMODI
>
> On Thu, Jul 7, 2011
THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS
REGARDS
LKMODI
On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi wrote:
> Dear Members,
>
> Me attaching a sheet which relates to Excise duty payment.The result should
> be 5 of the next of the month of Invoice.We are currently doing it
*
hi L K modi use this formula in d4
=EOMONTH(C4,0)+5
*Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Thu, Jul 7, 2011 at 11:29 AM, Rajan_Verma wrote:
> *Use this in D4*
>
> *=DATE(YEAR(C4),MONTH(C4)+1,5)*
>
> * *
>
Use this in D4
=DATE(YEAR(C4),MONTH(C4)+1,5)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of L.K. Modi
Sent: Thursday, July 07, 2011 10:26 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ help regarding date formula
Dear Members,
Me
use this=DATE(YEAR(C4),MONTH(C4),5)
On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi wrote:
> Dear Members,
>
> Me attaching a sheet which relates to Excise duty payment.The result should
> be 5 of the next of the month of Invoice.We are currently doing it
> manually. But is there any formula b
