Hi,
How could I count days by 1) weekday type and 2) Actual data or not. Ideal result would show X day for "Weekend" for Actual data, Y day for "Holiday" for Forecast data.. etc.
- Index is a "Day" list from 1 to 31.
- Column "Weekday" and "Actual data" are manual input.
- "Value" is a supporting column. Feel free to change the format or add/delete.

Ideal result:

Thanks,
Jane