Testing a date for being a working day

[#1]

I want to represent some data in a calendar style and want to show the non-working days as greyed out. I have the data displaying OK but cannot crack the weekend bit. I'm not too worried about bank holidays.Any ideas?

[#2]

HI Colin,

Please try creating a variable :

LET vDate =weekday(date(YourDateField()))

Then an If Statement like example: If($(vDate) = 'Sat',LightBlue()).

Hope it helps.

Stefan

[#3]

Hi Stefan

Close

This is what I've done

=if(weekday(makedate([Absence Year],[Absence Month],[Absence Day])) ='Sat', green() ,white())

but still only highlighting those cells where there is source data.

[#4]

Try :

=if(weekday(makedate([Absence Year],[Absence Month],[Absence Day])) ='Sat' or

weekday(makedate([Absence Year],[Absence Month],[Absence Day])) ='Sun', green() ,white())

[#5]

As you can see it is correctly highlighting where there are entries but for the rest of the chard we background is still light blue. I'd like to show weekends as green throughout the chart like it would be on a calendar.

Thanks for your efforts so far, keep them coming