Todays Date VBA for column

Originally Posted by bakerman2

Manny, I would strongly advice to re-design your late Sheet into a 7 column data sheet like Name|Team manager|Day|Date|Due|Logged|Status.
This way you open up a lot more possibilities like AutoFilter, AdvancedFilter and you could get your PivotTable Data straight from your Late Sheet.
Thatway you wouldn't have to resort to an in between solution like you are trying now.

Thanks Bakerman, I realized this (and kept the vba sample in my back pocket). The Timecard attachment I posted includes the idea you pitched, but I am having difficulty with the formula pulling Due|Login|Status from the Late tab according to the agent name and the date