IF statement weekdays vs weekends

[edwardpestian]

I'm looking for an IF statement that basically says the following:

IF R6 = a weekend (Friday,Saturday,Sunday) then K36 = Data!CY8*(1.23)
IF R6 = a weekday (Monday - Thursday) then K36 = Data!CY*(1.13)

I'm not sure how to have it determing the weekends vs weekdays.

Thanks in advance.

EP

 

[Lilliabeth]

then K36 = Data!CY*(1.13)

Assume you meant CY8




=IF(WEEKDAY(R6,2)>5,data!CY8*1.23,data!CY8*1.13)

 

[edwardpestian]

Thanks Lilliabeth. Works perfect.

Regards,

EP

 

[byundt]

If you want Friday to be part of the weekend, you need to change the 5 in WEEKDAY to a 4:

=Data!CY8*IF(WEEKDAY(R6,2)>4,1.23,1.13)

Brad