Calculate Variance in Days

Darcy Herold

I need to create a formula that calculates the total number of days an employee is in training.

One cell in my sheet is the Training Start Date.

One cell in my sheet is Today's Date

I need this cell to calculate the number of days between these to days.

I tried

=NETDAYS(start_date, end_date) and it give me #UNPARSEABLE

David Joyeuse

Hi @Darcy Herold

Try this instead:

=NETDAYS([Start Date Column]@row, [End Date Column]@row)

Hope it helped!