Color for dates

[Nikhith]

Hi,

I have one date field in table

Ex:

03-01-2019

04-01-2019

-------

24-01-2019.

I want display first five dates(03-01-2019 to 07-01-2019) in one color and next two dates (08-01-2019 to 09-01-2019) in one color.

Again next five days(10-01-2019 to 15-01-2019) in one color and next two dates (16-01-2019 to 18-01-2019) in one color.

The above rule for total date field.

Thaks,

Nikil

[Jacek]

=if( match( Mod(RowNo(),7), 0,6), rgb(255,0,0), rgb(0,0,255) )

[lironbaram]

hi

you can do it by using weekday for setting a date color 

in your example 

in the background example of the font example , you'll use 

=if(WeekDay(Date)<>2 and weekday(Date)<>3,green(),red())

will do the trick

[Nikhith]

Hi
Can u give me a Example

[Jacek · Accepted solution]

[Nikhith]

Thanks Jacek , It's Working
Regards,
Nikil