> 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&#x
On Sun, 7/30/17, 'Yu Spain' via MS EXCEL AND VBA MACROS
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
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
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 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
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 Sc
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 th
Please use the following formula in the cell C2
="WK"&INT((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,
>
