Forum Discussion
Ahmed Al Ameri
Mar 11, 2017Copper Contributor
Calculating Duration
Hello, I would like to know which formula I can use in days calculation between two dates (Counting the first date). For example: I have a course starting on 1/4/2017 and ending on 5/4/2017 so the...
JohnnieThomas
Mar 12, 2017Microsoft
Hi Ahmed
If your have date values stored in your cells then, End_Date - Start_Date +1 gives you the duration in days. As far as i recall, there are know special functions for this, just using regular subtraction and addition on date values.