Forum Discussion
Data validation rule
Hi,
am working on five columns. The first column is date, the second column is time in, the third column is time out. If I want the fourth column to to give a calculated value (time out minus time in) only when the date falls on a weekday and the fifth column to give the calculated value (time out minus time in) only in weekends or a given list of dates, how can I go about this?
1 Reply
Something like the attached? Also can you clarify the part about the list of dates.
Do you need the weekday result not to show if the the date falls in the list?
