Hi Everyone,
I am trying to calculate the number of days a year someone was in a location using a start and end date. Any idea how to do this.
Example:
So in this case, I need to know the number of days in 2020, 2021 and 2022.
Thanks!!
I am trying to calculate the number of days a year someone was in a location using a start and end date. Any idea how to do this.
Example:
Period Start Date | Period End Date |
7/20/2020 | 12/31/2022 |
So in this case, I need to know the number of days in 2020, 2021 and 2022.
Thanks!!