Highlight work starting on a weekend

Tom Roy

I was planning to use 

=IF(OR(WEEKDAY([Start]1) = 1, WEEKDAY([Start]1) = 7), "Weekend", "Weekday")

to highlight work starting on a weekend.Where 1 is Sunday and 7 is Saturday. And then use Cond Format as suggested by Greg Gates. 

Says "Unparseable"

My Start is Date job starts column and Weekday is column indicating weekday or weekend

J. Craig Williams

The formula looks fine. If there were not date in the date column, you would get an #INVALID DATA TYPE error, not #UNPARSEABLE

If the [Start] column is valid, as soon as you hit 'Enter' in the cell, the [] should go away (they are not needed since the column name has no special characters or does not end in a number. 

If they do not, verify your name.

If they do, both instances in the formula should be syntax-colored.

If you retyped the formula into the post here, then recheck it in the original source.

I copied your formula into my sheet and it works fine.

Craig

Jason Anderson

Just did a test and it seems like your formula would work fine if the targeted field is a date field. 

=IF(OR(WEEKDAY([Start Date]10) = 1, WEEKDAY([Start Date]10) = 7), "Weekend", "Weekday")

See rows 10 -12 in my Test formulas