On Mon, 5/1/17, 'Karleen Biggs' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Weekend rates to place in range
To: excel-macros@googlegroups.com
Date: Monday, May 1, 201
On Sun, 4/30/17, sleek wrote:
Subject: Re: $$Excel-Macros$$ Weekend rates to place in range
To: "MS EXCEL AND VBA MACROS"
Cc: julienneschind...@yahoo.com
Date: Sunday, April 30, 2017, 5:03 PM
"We denote that it formulated i
Schindler wrote:
>
>
>
> On Sun, 4/30/17, sleek > wrote:
>
> Subject: Re: $$Excel-Macros$$ Weekend rates to place in range
> To: "MS EXCEL AND VBA MACROS" >
> Date: Sunday, April 30, 2017, 9:27 AM
>
> Ok,You mean cell B3 rather, i am doing that
>
On Sun, 4/30/17, sleek wrote:
Subject: Re: $$Excel-Macros$$ Weekend rates to place in range
To: "MS EXCEL AND VBA MACROS"
Date: Sunday, April 30, 2017, 9:27 AM
Ok,You mean cell B3 rather, i am doing that
now.Then for C column , i w
Ok,
You mean cell B3 rather, i am doing that now.
Then for C column , i will modify the formula & place as such:
=IF(OR(WEEKDAY(A3,2)=6,WEEKDAY(A3,2)=7),$M$4,180)
Thanks for time saving tip Ashsih bhalara, I was trying advanced filter,
conditional formatting, but i suppose when i do pose a proble
Hi Sleek,
Use below condition in cell A3 to get output as per your requirement.
=IF(OR(WEEKDAY(A3,2)=6,WEEKDAY(A3,2)=7),$L$4,150)
Regards
Ashish Bhalara
On Sat, Apr 29, 2017 at 7:29 PM, 'Sleek' via MS EXCEL AND VBA MACROS <
excel-macros@googlegroups.com> wrote:
> Is there a simpler way to inpu
Is there a simpler way to input weekend rates ?
see my worksheet !!
I used conditional formatting to highlight weekends but to input range of
dates seems like i have to do in quite a bit of typing !!
I suspect probably using advanced filtering may help here !!
--
Are you =EXP(E:RT) or =NOT(E
