Support Board

Date/Time: Sun, 11 May 2025 15:02:34 +0000

Post From: Speadsheet study issue

[2014-10-24 15:21:17] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4214
By default, the WEEKDAY function input for Sunday is 1. Use 2 for Monday. =IF(AND(WEEKDAY(A3)=2,A4-INT(A4)<TIMEVALUE("03:45:00"),A3-INT(A3)>=TIMEVALUE("03:45:00")),B3,K4) http://office.microsoft.com/en-us/excel-help/weekday-HP005209336.aspx?CTT=5&origin=HP005204211