Thread: IF statement with Weekends vs. weekdays
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edwardpestian
 
Posts: n/a
Default IF statement with Weekends vs. weekdays

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


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=539612

Reply With QuoteReply With Quote