I have a start date and end date and want to calculate what percentage of days has passed since the start date.
I will also have to check whether the start date has been reached and if passed the end date it would be 100% and not keep counting.
I have a formula numeric field that calculates the total number of days between start and finish ToDays([End Date]-[Start Date])
I have a formula numeric field that needs to calculate number of days passed since start but it needs modifying to encompass if the start date has been reached otherwise its 0. ToDays(Today()-[Start Date])
Then I created another formula numeric % field to calculate the difference between these 2 but I get some completely weird results.