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, Avinas
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
stead
of true i want date and time to come in this format (m/d/ h:mm AM/PM)
can anyone please help me to get this done by macro or something in this
regards.
--
Thanks and Regards,
Avinash Patil
"Love does not happen its a choice. Its not magic or fate, but it is when a
person
t; See attached that eliminates the need for Hyperlinks
> Look in the ThisWorkbook module and the sheet module
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Monday, January 30, 2012 9:09 AM
> To: excel-macros@googlegroups.com
>
t; See attached that eliminates the need for Hyperlinks
> Look in the ThisWorkbook module and the sheet module
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> From: Avinash Patil
> Sent: Monday, January 30, 2012 9:09 AM
> To: excel-macros@googlegroups.com
>
Hyperlink in last field to each row entered
> ?
>
> I believe either you are explained too much in your post or missed to
> put the crux of your issue in lime light. :)
>
> Regards,
> DILIPandey
>
> On 1/27/12, Avinash Patil wrote:
> > Hi Experts,
> >
> &
Hi Masters,
can anybody please forward me excel dashboard designs i need dashboard
designs with all automations and vba work like drop downs , charts, graphs
"a dashboard with full graphical and customization interface"
i'll be realy greatfull to you guys please forward me the designs,
Regards,