Re: $$Excel-Macros$$ Help on Week Formula

2017-08-03 Thread Chandra Shekar 
Hello Team,

issue got resolved. Thanks All :)

Regards,

Chandru

On Mon, Jul 31, 2017 at 8:42 AM, 'Storey Thomas' via MS EXCEL AND VBA
MACROS <excel-macros@googlegroups.com> wrote:

>
> 
> On Sun, 7/30/17, 'Yu Spain' via MS EXCEL AND VBA MACROS <
> excel-macros@googlegroups.com> wrote:
>
>  Subject: Re: $$Excel-Macros$$ Help on Week Formula
>  To: excel-macros@googlegroups.com
>  Date: Sunday, July 30, 2017, 11:56 PM
>
>
>  
>  On Sun, 7/30/17, 'Martinez David' via
>  MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
>  wrote:
>
>   Subject: Re: $$Excel-Macros$$ Help on
>  Week Formula
>   To: excel-macros@googlegroups.com
>   Date: Sunday, July 30, 2017, 8:42 PM
>
>
>
>  
>   On Sun, 7/30/17, 'Hopkins Ruben' via
>  MS
>   EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
>   wrote:
>
>Subject: Re: $$Excel-Macros$$
>  Help on
>   Week Formula
>To: excel-macros@googlegroups.com
>Date: Sunday, July 30, 2017,
>  3:31 PM
>
>
>
>
>  ------------
>On Sun, 7/30/17, Chandra Shekar
>  <chandrashekarb@gmail.com>
>wrote:
>
> Subject: Re: $$Excel-Macros$$
>   Help on
>Week Formula
> To: excel-macros@googlegroups.com
> Date: Sunday, July 30, 2017,
>   2:57 PM
>
> Hello
> Paul,
> For Ex: If I
> mention date as 07/01/2017(Sat)
>formula should give Week 1
> from there every week it should
>increase by 1.1)
> 07-01-2017 to 07-07-2017 =
>   Week12)
>22-01-2017 to
> 28-07-2017 = Week43) 29-07-2017
>   -
>04-08-2017 =
> Week5
> Regards,
> Chandru
> On Tue, Jul 25, 2017 at
> 4:31 PM, Paul Schreiner <schreiner_p...@att.net>
> wrote:
> I
> think you'll need to be more
>   specific
>on how you want
> the "weeks" calculated.For
> instance, in
>   August (2017) August 1
>is on  a
> Tuesday.
> so,
> the weeks are handled:
>
> but,
> July 1 is on a Saturday,so,
> does Week 1 only have a single
>   day?
> Or
> is July 1 counted as part of
>   week 5 of
>June.If
> so, what is the minimum number
>   of days
>counted in a week
> 1?
> Or
> are you wanting a simple count
>   of
>days:Week
> 1 = first 7 daysWeek
> 2 = Second 7 daysetc.
>
>Paul--
> ---
> “Do
> all the good you can,
> By all the means you
> can,
> In all the ways you can,
> In all the places you can,
> At
> all the times you can,
> To all the people you
> can,
> As long as ever you can.” -
>   John
> Wesley
> --
> ---
>
>
>
>   On Tuesday, July 25, 2017
>   3:34
>AM,
> Chandra Shekar <chandrashekarb@gmail.com>
> wrote:
>
>
>  Hello Team,
> Could you please help me in
>   attached
> week formula.
> Regards,
> Chandru
>
>
>
> --
>
> 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
>

Re: $$Excel-Macros$$ Help on Week Formula

2017-07-30 Thread 'Storey Thomas' via MS EXCEL AND VBA MACROS 


On Sun, 7/30/17, 'Yu Spain' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Help on Week Formula
 To: excel-macros@googlegroups.com
 Date: Sunday, July 30, 2017, 11:56 PM
 
 
 
 On Sun, 7/30/17, 'Martinez David' via
 MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Help on
 Week Formula
  To: excel-macros@googlegroups.com
  Date: Sunday, July 30, 2017, 8:42 PM
  
  
 
 
  On Sun, 7/30/17, 'Hopkins Ruben' via
 MS
  EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Help on
  Week Formula
   To: excel-macros@googlegroups.com
   Date: Sunday, July 30, 2017,
 3:31 PM
   
   
  
 
 
   On Sun, 7/30/17, Chandra Shekar
 <chandrashekarb@gmail.com>
   wrote:
   
    Subject: Re: $$Excel-Macros$$
  Help on
   Week Formula
    To: excel-macros@googlegroups.com
    Date: Sunday, July 30, 2017,
  2:57 PM
    
    Hello
    Paul,
    For Ex: If I
    mention date as 07/01/2017(Sat)
   formula should give Week 1
    from there every week it should
   increase by 1.1)
    07-01-2017 to 07-07-2017 =
  Week12)
   22-01-2017 to
    28-07-2017 = Week43) 29-07-2017
  -
   04-08-2017 =
    Week5
    Regards,
    Chandru
    On Tue, Jul 25, 2017 at
    4:31 PM, Paul Schreiner <schreiner_p...@att.net>
    wrote:
    I
    think you'll need to be more
  specific
   on how you want
    the "weeks" calculated.For
    instance, in
  August (2017) August 1
   is on  a
    Tuesday.
    so,
    the weeks are handled:
    
    but,
    July 1 is on a Saturday,so,
    does Week 1 only have a single
  day?
    Or
    is July 1 counted as part of
  week 5 of
   June.If
    so, what is the minimum number
  of days
   counted in a week
    1?
    Or
    are you wanting a simple count
  of
   days:Week
    1 = first 7 daysWeek
    2 = Second 7 daysetc.
   
   Paul--
    ---
    “Do
    all the good you can,
    By all the means you
    can,
    In all the ways you can,
    In all the places you can,
    At
    all the times you can,
    To all the people you
    can,
    As long as ever you can.” -
  John
    Wesley
    --
    ---
    
    
     
      On Tuesday, July 25, 2017
  3:34
   AM,
    Chandra Shekar <chandrashekarb@gmail.com>
    wrote:
      
    
     Hello Team,
    Could you please help me in
  attached
    week formula.
    Regards,
    Chandru
    
    
    
    -- 
    
    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+unsubscribe@
    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)

Re: $$Excel-Macros$$ Help on Week Formula

2017-07-30 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS 


On Sun, 7/30/17, 'Martinez David' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Help on Week Formula
 To: excel-macros@googlegroups.com
 Date: Sunday, July 30, 2017, 8:42 PM
 
 
 
 On Sun, 7/30/17, 'Hopkins Ruben' via MS
 EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Help on
 Week Formula
  To: excel-macros@googlegroups.com
  Date: Sunday, July 30, 2017, 3:31 PM
  
  
 
 
  On Sun, 7/30/17, Chandra Shekar <chandrashekarb@gmail.com>
  wrote:
  
   Subject: Re: $$Excel-Macros$$
 Help on
  Week Formula
   To: excel-macros@googlegroups.com
   Date: Sunday, July 30, 2017,
 2:57 PM
   
   Hello
   Paul,
   For Ex: If I
   mention date as 07/01/2017(Sat)
  formula should give Week 1
   from there every week it should
  increase by 1.1)
   07-01-2017 to 07-07-2017 =
 Week12)
  22-01-2017 to
   28-07-2017 = Week43) 29-07-2017
 -
  04-08-2017 =
   Week5
   Regards,
   Chandru
   On Tue, Jul 25, 2017 at
   4:31 PM, Paul Schreiner <schreiner_p...@att.net>
   wrote:
   I
   think you'll need to be more
 specific
  on how you want
   the "weeks" calculated.For
   instance, in
 August (2017) August 1
  is on  a
   Tuesday.
   so,
   the weeks are handled:
   
   but,
   July 1 is on a Saturday,so,
   does Week 1 only have a single
 day?
   Or
   is July 1 counted as part of
 week 5 of
  June.If
   so, what is the minimum number
 of days
  counted in a week
   1?
   Or
   are you wanting a simple count
 of
  days:Week
   1 = first 7 daysWeek
   2 = Second 7 daysetc.
  
  Paul--
   ---
   “Do
   all the good you can,
   By all the means you
   can,
   In all the ways you can,
   In all the places you can,
   At
   all the times you can,
   To all the people you
   can,
   As long as ever you can.” -
 John
   Wesley
   --
   ---
   
   
    
     On Tuesday, July 25, 2017
 3:34
  AM,
   Chandra Shekar <chandrashekarb@gmail.com>
   wrote:
     
   
    Hello Team,
   Could you please help me in
 attached
   week formula.
   Regards,
   Chandru
   
   
   
   -- 
   
   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+unsubscribe@
   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 em

Re: $$Excel-Macros$$ Help on Week Formula

2017-07-30 Thread 'Martinez David' via MS EXCEL AND VBA MACROS 


On Sun, 7/30/17, 'Hopkins Ruben' via MS EXCEL AND VBA MACROS 
<excel-macros@googlegroups.com> wrote:

 Subject: Re: $$Excel-Macros$$ Help on Week Formula
 To: excel-macros@googlegroups.com
 Date: Sunday, July 30, 2017, 3:31 PM
 
 
 
 On Sun, 7/30/17, Chandra Shekar <chandrashekarb@gmail.com>
 wrote:
 
  Subject: Re: $$Excel-Macros$$ Help on
 Week Formula
  To: excel-macros@googlegroups.com
  Date: Sunday, July 30, 2017, 2:57 PM
  
  Hello
  Paul,
  For Ex: If I
  mention date as 07/01/2017(Sat)
 formula should give Week 1
  from there every week it should
 increase by 1.1)
  07-01-2017 to 07-07-2017 = Week12)
 22-01-2017 to
  28-07-2017 = Week43) 29-07-2017 -
 04-08-2017 =
  Week5
  Regards,
  Chandru
  On Tue, Jul 25, 2017 at
  4:31 PM, Paul Schreiner <schreiner_p...@att.net>
  wrote:
  I
  think you'll need to be more specific
 on how you want
  the "weeks" calculated.For
  instance, in August (2017) August 1
 is on  a
  Tuesday.
  so,
  the weeks are handled:
  
  but,
  July 1 is on a Saturday,so,
  does Week 1 only have a single day?
  Or
  is July 1 counted as part of week 5 of
 June.If
  so, what is the minimum number of days
 counted in a week
  1?
  Or
  are you wanting a simple count of
 days:Week
  1 = first 7 daysWeek
  2 = Second 7 daysetc.
   Paul--
  ---
  “Do
  all the good you can,
  By all the means you
  can,
  In all the ways you can,
  In all the places you can,
  At
  all the times you can,
  To all the people you
  can,
  As long as ever you can.” - John
  Wesley
  --
  ---
  
  
   
    On Tuesday, July 25, 2017 3:34
 AM,
  Chandra Shekar <chandrashekarb@gmail.com>
  wrote:
    
  
   Hello Team,
  Could you please help me in attached
  week formula.
  Regards,
  Chandru
  
  
  
  -- 
  
  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+unsubscribe@
  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+unsubscribe@
  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 concis

Re: $$Excel-Macros$$ Help on Week Formula

2017-07-30 Thread 'Hopkins Ruben' via MS EXCEL AND VBA MACROS 


On Sun, 7/30/17, Chandra Shekar <chandrashekarb@gmail.com> wrote:

 Subject: Re: $$Excel-Macros$$ Help on Week Formula
 To: excel-macros@googlegroups.com
 Date: Sunday, July 30, 2017, 2:57 PM
 
 Hello
 Paul,
 For Ex: If I
 mention date as 07/01/2017(Sat) formula should give Week 1
 from there every week it should increase by 1.1)
 07-01-2017 to 07-07-2017 = Week12) 22-01-2017 to
 28-07-2017 = Week43) 29-07-2017 - 04-08-2017 =
 Week5
 Regards,
 Chandru
 On Tue, Jul 25, 2017 at
 4:31 PM, Paul Schreiner <schreiner_p...@att.net>
 wrote:
 I
 think you'll need to be more specific on how you want
 the "weeks" calculated.For
 instance, in August (2017) August 1 is on  a
 Tuesday.
 so,
 the weeks are handled:
 
 but,
 July 1 is on a Saturday,so,
 does Week 1 only have a single day?
 Or
 is July 1 counted as part of week 5 of June.If
 so, what is the minimum number of days counted in a week
 1?
 Or
 are you wanting a simple count of days:Week
 1 = first 7 daysWeek
 2 = Second 7 daysetc.
  Paul--
 ---
 “Do
 all the good you can,
 By all the means you
 can,
 In all the ways you can,
 In all the places you can,
 At
 all the times you can,
 To all the people you
 can,
 As long as ever you can.” - John
 Wesley
 --
 ---
 
 
  
   On Tuesday, July 25, 2017 3:34 AM,
 Chandra Shekar <chandrashekarb@gmail.com>
 wrote:
   
 
  Hello Team,
 Could you please help me in attached
 week formula.
 Regards,
 Chandru
 
 
 
 -- 
 
 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+unsubscribe@
 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+unsubscribe@
 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 pos

Re: $$Excel-Macros$$ Help on Week Formula

2017-07-30 Thread Chandra Shekar 
Hello Paul,

For Ex: If I mention date as 07/01/2017(Sat) formula should give Week 1
from there every week it should increase by 1.
1) 07-01-2017 to 07-07-2017 = Week1
2) 22-01-2017 to 28-07-2017 = Week4
3) 29-07-2017 - 04-08-2017 = Week5

Regards,

Chandru

On Tue, Jul 25, 2017 at 4:31 PM, Paul Schreiner 
wrote:

> I think you'll need to be more specific on how you want the "weeks"
> calculated.
> For instance, in August (2017) August 1 is on  a Tuesday.
>
> so, the weeks are handled:
> [image: Inline image]
>
> but, July 1 is on a Saturday,
> so, does Week 1 only have a single day?
> [image: Inline image]
>
> Or is July 1 counted as part of week 5 of June.
> If so, what is the minimum number of days counted in a week 1?
>
> Or are you wanting a simple count of days:
> Week 1 = first 7 days
> Week 2 = Second 7 days
> etc.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Tuesday, July 25, 2017 3:34 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>
> Hello Team,
>
> Could you please help me in attached week formula.
>
> Regards,
>
> Chandru
> --
> 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

Re: $$Excel-Macros$$ Help on Week Formula

2017-07-25 Thread Paul Schreiner 
I think you'll need to be more specific on how you want the "weeks" 
calculated.For instance, in August (2017) August 1 is on  a Tuesday.
so, the weeks are handled:

but, July 1 is on a Saturday,so, does Week 1 only have a single day?
Or is July 1 counted as part of week 5 of June.If so, what is the minimum 
number of days counted in a week 1?
Or are you wanting a simple count of days:Week 1 = first 7 daysWeek 2 = Second 
7 daysetc.
 Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
- 

On Tuesday, July 25, 2017 3:34 AM, Chandra Shekar 
 wrote:
 

 Hello Team,
Could you please help me in attached week formula.
Regards,
Chandru-- 
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$$ Help on Week Formula

2017-07-25 Thread Aindril De 
Please use the following formula in the cell C2
="WK"((DAY(A2)+6)/7)

And drag down to copy the formula.
Cheers!!
Aindril

On Tue, Jul 25, 2017 at 1:03 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hello Team,
>
> Could you please help me in attached week formula.
>
> Regards,
>
> Chandru
>
> --
> 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.
>



-- 

Warm Regards,
Aindril De
Ph: 9811300157

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