I would like to show work days lapsed from today's date

**telcocook** · 12-31-2014, 09:31 AM

Hello. I would like help with a formula that would calculate work days lapsed using a cell with a start date and a cell with the '=Today()' function.

Thank you.

**6StringJazzer** · 12-31-2014, 09:40 AM

If the start date is in A1, the elapsed workdays is given by

Formula:

Please Login or Register  to view this content.

where the third argument is an optional range reference containing a list of dates for weekdays that are non-working days. Please look up Excel Help for NETWORKDAYS for a complete explanation.

**telcocook** · 12-31-2014, 02:18 PM

Thank you so much for the formula. Before I read your reply I tried out the following formula...

=A1-(WORKDAY(E4,5))

Where A1 has '=Today()' and E4 has a starting date and 5 is the number of work days for the week. I will do as you suggest and read up on NETWORKDAYS.

Thank you again!