Hi,
I’m trying to automate end date (Plan. Forsendelse) by using General Castor.
I have it set up this way:
Base end date on start date (Plan. Start) + a colomn i’ve got which shows how many days of work a project is(Dager med sveis).
Say start date is 28.02.2024, and the days of work colomn shows 12 days, i want end date (Plan. Forsendelse) to be 17.03.2024.
I have tried several forumlas, non work, all of them just show 01.01.1970. (Gotten help from CHATGPT)
The formula we tried + several others is:
TEXT(WORKDAY(DATEVALUE({Plan. start}), {Dager med sveising}), “YYYY-MM-DD”)
+
TEXT(WORKDAY(DATEVALUE({Plan. start}), {Dager med sveising}), “YYYY-MM-DD”)
Would greatly appreciate if someone could help me with this!
