I am trying to populate a specific date value for a specific column ("H") for a non-blank column ("A") using the below formula. I want this formula to be invoked when a user click the save button (or create a custom button to invoke the below formula)

Any direction or guidance on how to incorporate this into a macro code is greatly appreciated.

=IF(ISBLANK($A2),"",IF(WEEKDAY(TODAY())<4,(TODAY()+(-1-WEEKDAY(TODAY()))),(TODAY()+(6-WEEKDAY(TODAY())))))

thanks