Forum Discussion
lisab705
Jul 24, 2022Copper Contributor
If date is a specific day, then add a number of days
Hi folks, Trying to work out a formula for a weekly updating date field. We have 6 regular meetings on different days of the week, and I want it to show the date for next week. I have todays d...
- Jul 26, 2022
in E1 and copy right until J1:
=$C1-WEEKDAY($C1,3)+MATCH(E3, {"Sun","Mon","Tue","Wed","Thu","Fri","Sat"}, 0)-2in E2 and copy right until J2:
=E1+7Corresponding sample attached