Forum Discussion
Solved
Calculating future dates from a project start date
Hi all, Im looking to do a calculation that will provide me with future 'no later than' dates for a survey. I have a project start date (01.01.20) and project end date (31.12.20) and want a ...
eilidh3 , Both as new columns
mid date = [start_date]+ quotient(datediff([start_date],[end_date],day),2) one month after date = date(year([end_date]),month([end_date])+1,day([end_date]))
eilidh3 , Both as new columns
mid date = [start_date]+ quotient(datediff([start_date],[end_date],day),2)
one month after date = date(year([end_date]),month([end_date])+1,day([end_date]))amitchandak Easy when you know how 🙂 Thank you!! 👍
