Looking for some help adding 2 fields together into a third date field. Below are the 2 fields needed to calculate/update the third field.
'Actual Start Date' (date field):
PLUS
'Assignment Length' (decimal field which is entered in as months. So this would read as 5 months)
EQUALS
'Estimated End Date' (date field)
Not sure if this would end up just being a calculated field but wanted to know if it can be done.
Thanks in advance.
I believe this could be done using a calculated field
You could use something like ADDMONTHS (date field, length field) to add a whole month (e.g. 28th June + 5 months = 28th November)
If you wanted to count a month as 28 days, you could use a calculated field to multiply 5 x 28 then add that to your original date
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156