Is it possible to convert the below formulas to one macro? I have been at this for serveral days and cant make any headway.
| Due Date: | = TEXT(WORKDAY('COPR NOTES'!$C$2,7),"MM/DD/YYYY") |
| Push Date To Nearest Weekday: | =TEXT(IF(WEEKDAY($C$3)=7,$C$3+2,IF(WEEKDAY($C$3)=1,$C$3+1,$C$3)),"MM/DD/YYYY") |
| Date Imported From Textbox: | 8/28/2021 |
| Due Date: | 09/07/2021 |
| Push Date To Nearest Weekday: | 08/30/2021 |
| Date Imported From Textbox: | 8/28/2021 |