Feb 16 2024 02:12 AM
Hi,
I have a calculated column on a SP list to add the date of an exam for a training course. The course is split into Week 1 (Manual Entry from MS Form) with Week 2 and the exam date calculated as 14 days after and 28 days after respectively.
I've been informed that the exam date is always the first Wednesday of the following month rather than an exact 28 days. Question is, is this possible and if so, how would you construct the formula?