Hi
Jim,
Yes, you can use the
NETWORKDAYS function to calculate the number of days between a start date and today's date. Here's how you can do it:
- In cell B1, enter the following formula:
Code:
=NETWORKDAYS(A1,TODAY())
- Press Enter to calculate the number of working days between the start date in cell A1 and today's date.
- The result will be displayed in cell B1 as the number of days between the start date and today's date.
Note that the
NETWORKDAYS function excludes weekends and any dates that you specify as holidays. If you want to include weekends, you can use the
DATEDIF function instead. Here's how:
- In cell B1, enter the following formula:
Code:
=DATEDIF(A1,TODAY(),"d")
- Press Enter to calculate the number of days between the start date in cell A1 and today's date.
- The result will be displayed in cell B1 as the number of days between the start date and today's date, including weekends.