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 |