Based on date, value should display in a Report column

Content

Hi All,

There are two columns in a Report. One is Date column which display date in DD-MM-YYY HH:MM AM/PM format and one is Items column (will display item names like Item1, Item2, Item3 and Item4).

The third column should have values based on the date.

• Items=Item1 and If the Day of the week is a Week Day, then value should be V1.
• Items=Item2 and If the Day of the week is a Week Day then value should be V2, also If the Day of the week is a Saturday then value should be V3.