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
Hi all,
I think this information can be useful for you. If you plan to get your
website, here is one good free web hosting provider to choose -
000webhost.com
They provide hosting absolutely free, there is no catch. You get 1500 MB of
disk space and 100 GB bandwidth. They also have cPanel cont
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
