forest1959
New Member
- Joined
- Mar 16, 2010
- Messages
- 30
- Office Version
- 2016
- Platform
- Windows
Good Afternoon
Can anyone please point me in the right direction to solve the following?
I have an annual leave spreadsheet eg
Employers Name Leave Start Date Leave End Date
Paul 08/02/2021 15/02/2021
I can count the number of days the employee is off thanks to the networkdays formula, but is there away of counting how many days during this period that have passed and how many are in the future
So on the example above, if todays date was 10/02/2021, how can i count how many days have passed (including "today"), and how many are in the future?
Regards
Paul
Can anyone please point me in the right direction to solve the following?
I have an annual leave spreadsheet eg
Employers Name Leave Start Date Leave End Date
Paul 08/02/2021 15/02/2021
I can count the number of days the employee is off thanks to the networkdays formula, but is there away of counting how many days during this period that have passed and how many are in the future
So on the example above, if todays date was 10/02/2021, how can i count how many days have passed (including "today"), and how many are in the future?
Regards
Paul