If function for workday & weekend

I

insplkm

Hi, I need help to setup a function with the following concept:

in A1, If today()-1 is a workday, take value directly from C2, if its
weekend, take value from C2 divide by 3.

Thanks.
 
R

Ron Rosenfeld

Hi, I need help to setup a function with the following concept:

in A1, If today()-1 is a workday, take value directly from C2, if its
weekend, take value from C2 divide by 3.

Thanks.
Click to expand...

=if(weekday(today()-1,3)<=4,c2,c2/3)


--ron
 
Top