subject:"$$Excel\-Macros$$ help regarding date formula"

Re: $$Excel-Macros$$ help regarding date formula

2011-07-07 Thread karunanithi ramaswamy

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, 11:26 AM


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 by which we can do that fast and in less time. Hope you 
wil surely help me.


 
Regards
LKModi
 



-- 

--

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




-- 
Regards
 
Ashish Koul
akoul.blogspot.com
http://akoul.posterous.com/


akoul.wordpress.com
My Linkedin Profile
 

P Before printing, think about the environment.
 





-- 

--

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

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

Re: $$Excel-Macros$$ help regarding date formula

2011-07-07 Thread karunanithi ramaswamy

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: Thursday, July 7, 2011, 10:25 AM

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 by which we can do that fast and in less time. Hope you 
wil surely help me.

 
Regards
LKModi
 



-- 

--

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

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

Re: $$Excel-Macros$$ help regarding date formula

2011-07-06 Thread ankur

*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 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 by which we can do that fast and in less
>> time. Hope you wil surely help me.
>>
>> Regards
>> LKModi
>>
>>
>> --
>>
>> --
>> 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/discussexcel
>>
>
>  --
>
> --
> 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/discussexcel
>

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

Re: $$Excel-Macros$$ help regarding date formula

2011-07-06 Thread L.K. Modi

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
> manually. But is there any formula by which we can do that fast and in less
> time. Hope you wil surely help me.
>
> Regards
> LKModi
>
>
> --
>
> --
> 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/discussexcel
>

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

Re: $$Excel-Macros$$ help regarding date formula

2011-07-06 Thread ankur

*
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)*
>
> * *
>
> *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 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 by which we can do that fast and in less
> time. Hope you wil surely help me.
>
>  
>
> Regards
>
> LKModi
>
>  
>
> --
>
> --
> 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/discussexcel
>
> --
>
> --
> 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/discussexcel
>

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

RE: $$Excel-Macros$$ help regarding date formula

2011-07-06 Thread Rajan_Verma

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 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 by which we can do that fast and in less
time. Hope you wil surely help me.

 

Regards

LKModi

 

-- 

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

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

Re: $$Excel-Macros$$ help regarding date formula

2011-07-06 Thread ashish koul

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 by which we can do that fast and in less
> time. Hope you wil surely help me.
>
> Regards
> LKModi
>
>
> --
>
> --
> 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/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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

$$Excel-Macros$$ help regarding date formula

2011-07-06 Thread L.K. Modi

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 by which we can do that fast and in less
time. Hope you wil surely help me.

Regards
LKModi

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


TEST SHEET.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ help regarding date formula

Re: $$Excel-Macros$$ help regarding date formula

Re: $$Excel-Macros$$ help regarding date formula

Re: $$Excel-Macros$$ help regarding date formula

Re: $$Excel-Macros$$ help regarding date formula

RE: $$Excel-Macros$$ help regarding date formula

Re: $$Excel-Macros$$ help regarding date formula

$$Excel-Macros$$ help regarding date formula

8 matches

Site Navigation

Mail list logo

Footer information