Forum Discussion
Getting milestone dates
Please check the attached, it may address your problem.
If it solved your problem then please mark it as the solution so others can see it.
Best,
Heya,
I don't really understand the logic you're trying to implement. I assume the dates are US format (Month/Day/Year) - the end date should be after start date. A simple calculation would return 57 days between start and end for Company A. If you calculate the milestone date only based on this variable, 25% would be ~14 days which added to the start date of 7th of October would mean 21st of October not 5th of November.
Unless I misunderstand the whole problem. How did you get to the 5th of November?
Cheers
my apologies, i really just filled in arbitrary dates for the milestone dates, but the logic is it would return a date for me thats within that start/end range that would correspond to when the planned rate should be at 25, 50, 75%, etc... complete
