BravoBravoAu
Board Regular
- Joined
- Nov 8, 2011
- Messages
- 63
- Office Version
- 2016
- Platform
- Windows
Hi experts - I'm looking for a macro to calculate the number of work days since a date (when a document was signed). Below is columns F and G from the workbook.
<tbody>
</tbody>
Now, I know that this can be fairly easily done with a NETWORK days formula, but here is the kicker, I want to be able to assign the macro to a shape at the top of the column (located in the header of column G) so that the 'workdays since' (G2) calculates the workdays between 01-January-2018 (F2) and todays date, when the cell is selected and the macro button is pressed.
Obviously if there are ten dates listed (F2:F11) that I want calculated in the corresponding 'workdays since' column (G2:G11), this would be identified by G2:G11 being selected and the macro button pressed.
Help!! Thanks in advance.
Document signed date | Workdays since |
01-January-2018 | |
15-February-2018 |
<tbody>
</tbody>
Now, I know that this can be fairly easily done with a NETWORK days formula, but here is the kicker, I want to be able to assign the macro to a shape at the top of the column (located in the header of column G) so that the 'workdays since' (G2) calculates the workdays between 01-January-2018 (F2) and todays date, when the cell is selected and the macro button is pressed.
Obviously if there are ten dates listed (F2:F11) that I want calculated in the corresponding 'workdays since' column (G2:G11), this would be identified by G2:G11 being selected and the macro button pressed.
Help!! Thanks in advance.