If its weekend(Sat, Sunday) or Holiday, should copy previous working day data and paste to these days

Hi @johns

I think a little more information is required to suggest something here.

However see below how can you identify that today or on someday is a weekend.

Thanks,
Prankur