subject:"$$Excel\-Macros$$ Date Formula"

Re: $$Excel-Macros$$ Date formula complicated Challengeing Required

2018-05-04 Thread amar takale

Any Solution?

On Mon, Apr 30, 2018 at 7:29 PM, amar takale  wrote:

>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Date formula for Age Calculation

2016-02-08 Thread Mandeep baluja


>
> Hey Amar, 
>

While doing  manipulations with date you must ensure the Format of System 
date format.Some people use mm/dd/ and others use dd/mm/ so if 
someone has provide you the data in his format and you'r date format is 
different from that it will shows you the error.

Note one thing First date in Excel is 01-01-1900 means year 1900, Any date 
beyond this date will not be accepted in any computer format you're using 
therefore 30/12/1889 will show you error I changed your formula to make it 
a date which follows the date format rules. Means Month should not 
be greater than 12,dates should not exceeds 31. 

Please find the attached Data 

Regards, 
Mandeep Baluja  
 

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Date formula.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Date formula for Age Calculation

2016-02-08 Thread amar takale

Dear Mandeep


Very Helpful and thanks providing this helpful knowledge regarding date
solution.


And Thank you very much for all


Regards

Amar



On Mon, Feb 8, 2016 at 3:06 PM, Mandeep baluja 
wrote:

> Hey Amar,
>>
>
> While doing  manipulations with date you must ensure the Format of System
> date format.Some people use mm/dd/ and others use dd/mm/ so if
> someone has provide you the data in his format and you'r date format is
> different from that it will shows you the error.
>
> Note one thing First date in Excel is 01-01-1900 means year 1900, Any date
> beyond this date will not be accepted in any computer format you're using
> therefore 30/12/1889 will show you error I changed your formula to make it
> a date which follows the date format rules. Means Month should not
> be greater than 12,dates should not exceeds 31.
>
> Please find the attached Data
>
> Regards,
> Mandeep Baluja
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Date formula for Age Calculation

2016-02-07 Thread GENIUS

LOOK AT THE ATTACHMENT

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


AGE CALCULATION.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Date formula for Age Calculation

2016-02-07 Thread amar takale

Dear all thanks for reply but i cant understand what you say.I except only
date formula in column D.

On Sun, Feb 7, 2016 at 9:36 PM, GENIUS  wrote:

> LOOK AT THE ATTACHMENT
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Date formula for Age Calculation

2016-02-06 Thread amar takale

Dear All

Here I required Date formula for Age Calculation but in cell date there are
some issue Value or text cell format,I cant understand. pls look matter,i
try it helper column but some date issue again.

Pls provide Date formula without helper column

Regards
Amar

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Date formula.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Date formula for Age Calculation

2016-02-06 Thread big smile

This is 1 st time i am sending other query's reply.

Otherwise i am always sending query only.

Thank you very much


Check this file too. It may also help you & our group too ..

You can add days also in today' s date

If u think to have some more correction & then let me know

On 6 February 2016 at 15:06, Abhishek Jain  wrote:

> Look at the second name "Carme" in your sheet.
>
> Your formula is picking up the first 02 digits of the DOB and taking them
> as 'month' and there is no 16th month in the calender.
>
> You either need to change your formula or the dates themselves.
>
> HTH
>
> On Sat, Feb 6, 2016 at 2:50 PM, amar takale  wrote:
>
>> Dear All
>>
>> Here I required Date formula for Age Calculation but in cell date there
>> are some issue Value or text cell format,I cant understand. pls look
>> matter,i try it helper column but some date issue again.
>>
>> Pls provide Date formula without helper column
>>
>> Regards
>> Amar
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


AGE CALU FILE.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Date formula for Age Calculation

2016-02-06 Thread Abhishek Jain

Look at the second name "Carme" in your sheet.

Your formula is picking up the first 02 digits of the DOB and taking them
as 'month' and there is no 16th month in the calender.

You either need to change your formula or the dates themselves.

HTH

On Sat, Feb 6, 2016 at 2:50 PM, amar takale  wrote:

> Dear All
>
> Here I required Date formula for Age Calculation but in cell date there
> are some issue Value or text cell format,I cant understand. pls look
> matter,i try it helper column but some date issue again.
>
> Pls provide Date formula without helper column
>
> Regards
> Amar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

RE: $$Excel-Macros$$ Date Formula

2011-07-26 Thread Daniel

Hello,

 

Have a look at the attached workbook.

 

Regards.

 

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nikhil Shah
Envoyé : lundi 25 juillet 2011 20:58
À : excel-macros@googlegroups.com
Cc : Maries waran
Objet : $$Excel-Macros$$ Date Formula

 

Dear All Members

Here I am posting my Question :

( 1 ). Starting Date : 25/08/2012 : Format will be dd/mm/
( 2 ). End Date : 05/05/2016 : Format will be dd/mm/

Now I want Answer in the Following manner :

( 1 ) . 31/08/2012...
( 2 ).  30/09/2012
( 3 ).  31/10/2012
( 4 ).  30/11/2012

Up to

05/05/2016 ---  End Date

This means..

I want the last date of each month from start Month to end Month and for
this  the days should be calculated...accordingly

The Months which have 31 days should be counted 31 and months which have 30
days should be counted 30,if start month is incomplete the days should be
calculated accordingly , For End Month the days should be counted up to the
mentioned date.

For Ex. : My Starting Dt.25/08 but August has 31 days So, I will count
Difference Of  6 Days ( 31/08 - 25/08 )
  My Ending Dt Will be 05/05/2016..So I will count only 5 days.

I want Formula Only  I Do Not Want VBA Code...And I am using Office
Professional Edition 2003 Version...

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


Dates.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Date Formula

2011-07-26 Thread XLS S

for month end date ...

=DATE(YEAR(A1),1+MONTH(A1),1)-1

On Tue, Jul 26, 2011 at 12:28 AM, Nikhil Shah nikhil201...@gmail.comwrote:

 Dear All Members

 Here I am posting my Question :

 ( 1 ). Starting Date : 25/08/2012 : Format will be dd/mm/
 ( 2 ). End Date : 05/05/2016 : Format will be dd/mm/

 Now I want Answer in the Following manner :

 ( 1 ) . 31/08/2012...
 ( 2 ).  30/09/2012
 ( 3 ).  31/10/2012
 ( 4 ).  30/11/2012

 Up to

 05/05/2016 ---  End Date

 This means..

 I want the last date of each month from start Month to end Month and for
 this  the days should be calculated...accordingly

 The Months which have 31 days should be counted 31 and months which have 30
 days should be counted 30,if start month is incomplete the days should be
 calculated accordingly , For End Month the days should be counted up to the
 mentioned date.

 For Ex. : My Starting Dt.25/08 but August has 31 days So, I will count
 Difference Of  6 Days ( 31/08 - 25/08 )
   My Ending Dt Will be 05/05/2016..So I will count only 5 days.

 I want Formula Only  I Do Not Want VBA Code...And I am using Office
 Professional Edition 2003 Version...

 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 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$$ Date Formula

2011-07-26 Thread Nikhil Shah

Hi Daniel

Thanks  for solving my problem.

Nikhil Shah

On Tue, Jul 26, 2011 at 5:01 PM, Daniel dcolarde...@free.fr wrote:

 Hello,

 ** **

 Have a look at the attached workbook.

 ** **

 Regards.

 ** **

 Daniel

 ** **

 *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
 *De la part de* Nikhil Shah
 *Envoyé :* lundi 25 juillet 2011 20:58
 *À :* excel-macros@googlegroups.com
 *Cc :* Maries waran
 *Objet :* $$Excel-Macros$$ Date Formula

 ** **

 Dear All Members

 Here I am posting my Question :

 ( 1 ). Starting Date : 25/08/2012 : Format will be dd/mm/
 ( 2 ). End Date : 05/05/2016 : Format will be dd/mm/

 Now I want Answer in the Following manner :

 ( 1 ) . 31/08/2012...
 ( 2 ).  30/09/2012
 ( 3 ).  31/10/2012
 ( 4 ).  30/11/2012

 Up to

 05/05/2016 ---  End Date

 This means..

 I want the last date of each month from start Month to end Month and for
 this  the days should be calculated...accordingly

 The Months which have 31 days should be counted 31 and months which have 30
 days should be counted 30,if start month is incomplete the days should be
 calculated accordingly , For End Month the days should be counted up to the
 mentioned date.

 For Ex. : My Starting Dt.25/08 but August has 31 days So, I will count
 Difference Of  6 Days ( 31/08 - 25/08 )
   My Ending Dt Will be 05/05/2016..So I will count only 5 days.

 I want Formula Only  I Do Not Want VBA Code...And I am using Office
 Professional Edition 2003 Version...

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

$$Excel-Macros$$ Date Formula

2011-07-25 Thread Nikhil Shah

Dear All Members

Here I am posting my Question :

( 1 ). Starting Date : 25/08/2012 : Format will be dd/mm/
( 2 ). End Date : 05/05/2016 : Format will be dd/mm/

Now I want Answer in the Following manner :

( 1 ) . 31/08/2012...
( 2 ).  30/09/2012
( 3 ).  31/10/2012
( 4 ).  30/11/2012

Up to

05/05/2016 ---  End Date

This means..

I want the last date of each month from start Month to end Month and for
this  the days should be calculated...accordingly

The Months which have 31 days should be counted 31 and months which have 30
days should be counted 30,if start month is incomplete the days should be
calculated accordingly , For End Month the days should be counted up to the
mentioned date.

For Ex. : My Starting Dt.25/08 but August has 31 days So, I will count
Difference Of  6 Days ( 31/08 - 25/08 )
  My Ending Dt Will be 05/05/2016..So I will count only 5 days.

I want Formula Only  I Do Not Want VBA Code...And I am using Office
Professional Edition 2003 Version...

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 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$$ Date formula complicated Challengeing Required

Re: $$Excel-Macros$$ Date formula for Age Calculation

Re: $$Excel-Macros$$ Date formula for Age Calculation

Re: $$Excel-Macros$$ Date formula for Age Calculation

Re: $$Excel-Macros$$ Date formula for Age Calculation

$$Excel-Macros$$ Date formula for Age Calculation

Re: $$Excel-Macros$$ Date formula for Age Calculation

Re: $$Excel-Macros$$ Date formula for Age Calculation

RE: $$Excel-Macros$$ Date Formula

Re: $$Excel-Macros$$ Date Formula

Re: $$Excel-Macros$$ Date Formula

$$Excel-Macros$$ Date Formula

12 matches

Site Navigation

Mail list logo

Footer information