Awesome man it's working thanks a TON!
Regards,
Avinash
Sent from my iPhone
On Oct 2, 2013, at 2:03 PM, ashish koul wrote:
=IF(B3=1,"PR -1 ",IF(AND(MOD(B2,4)=0,MOD(B3,4)<>0),"PR - "&
RIGHT(E2,LEN(E2)-4)+1,E2))
On Wed, Oct 2, 2013 at 1:43 PM, Avinash Patil wrote:
> Every 4 weeks are consider
=IF(B3=1,"PR -1 ",IF(AND(MOD(B2,4)=0,MOD(B3,4)<>0),"PR - "&
RIGHT(E2,LEN(E2)-4)+1,E2))
On Wed, Oct 2, 2013 at 1:43 PM, Avinash Patil wrote:
> Every 4 weeks are considered as 1 period that is the logic. And weeks are
> starting from sun to sat.
> This year was started on tuesday so last year's 2
Every 4 weeks are considered as 1 period that is the logic. And weeks are
starting from sun to sat.
This year was started on tuesday so last year's 2 days are also considered
in this calculations.
Sent from my iPhone
On Oct 2, 2013, at 10:17 AM, ashish koul wrote:
can u explain how what logic y
can u explain how what logic you have used to mark them as PR1 - PR -2
On Wed, Oct 2, 2013 at 3:09 AM, Avinash wrote:
> Hi all,
>
> can anyone please help me to get periodic calculations.
>
> attached is the sheet for your better understanding. i want same value
> highlighted in yellow by form
