Add weekend values to weekdays

[freshtomm]

Hi guys,

i need a VBA code to lookup for Saturday and Sunday rows, and values from that rows add to Friday values. After that, replace Saturday and Sunday values with zeroes. But if Saturday or Sunday are first days in a month, add those values to Monday. Is that possible?

File included.

Thanks.

Tomas

 

[Belleke]

Yes, it is possible, but with your example, No Go, you are not working with dates.
Attached, no VBA but this can be the next step.
(Dutch example)
In the example, hollydays and weekends are colored grey.
It is in Dutch but the tab feestdagen = hollydays (where I live) adjust the dates to your needs.
zondag = sunday etc, not that hard to understand.
The first step you have to take is rebuild your file and work with real dates. Sat and Sun are just text in your example, excel can't calculate with text.