TODAY()

Returns the current date. Recalculates automatically every day. Used for overdue calculations, SLA tracking, and date-based conditions.

=TODAY()

=TODAY()
=[Due Date]@row - TODAY()     // Days until due (negative = overdue)
=IF([Due Date]@row < TODAY(), "Overdue", "On Track")