Jul 10 2019 09:39 AM
Hello,
I am needing help calculating between two dates. I'm using the =DAY(end_date, start_date), however, I need the end and start dates to be included in the day count.
For example, If our start day is on 7/01 and our end day is on 7/24. Using the above formula gives me 23 days, however the job lasted 24 days because 7/01 was the first day on the job and 7/24 was the last day on the job. I wondered if there was a easier way for me to calculate this, or if I needed to just put a +1 after my formula.
Thank you in Advance!
Jul 10 2019 11:10 AM
SolutionJul 10 2019 11:11 AM
@Twifoo Thank you for your help! I will add one to my formula.
Jul 10 2019 11:17 AM
Aug 13 2019 12:45 AM
Jul 10 2019 11:10 AM
Solution