Carlandrewlewis
asked on
Excel week commencing formula
Is there a formula that when a name is entered into cell A2 the week commencing date automates in to cell B2? (Week commencing from a monday)
To Create a macro:
------------------
Alt + F11 to open the macro editor
For workbook event handlers:
In the project tree select as appropriate:
EXCEL : thisworkbook
In the workpane select as appropriate:
EXCEL : WorkBook
In the workpane select the required 'event', (i.e. 'Change').
Insert the required macro(s) into the selected subroutine.
Close the Visual Basic Editor.
Check Security as appropriate:
-------------------------- ----
In the application select Tools | Macro | Security
Select Medium
Select OK
Chris
------------------
Alt + F11 to open the macro editor
For workbook event handlers:
In the project tree select as appropriate:
EXCEL : thisworkbook
In the workpane select as appropriate:
EXCEL : WorkBook
In the workpane select the required 'event', (i.e. 'Change').
Insert the required macro(s) into the selected subroutine.
Close the Visual Basic Editor.
Check Security as appropriate:
--------------------------
In the application select Tools | Macro | Security
Select Medium
Select OK
Chris
ASKER
Is there a way to add this into this file. Basically when a date is entered into column A of 'New Seet' it should then automatically fill out column B with the week commencing that will then fill out column C with the week number. I'm just having trouble inserting the code in the right place....
Weekly-Pay-Schedule-1.xls
Weekly-Pay-Schedule-1.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works perfectly, thanks chris!!
You're welcome and thanks for the grade.
Chris
Chris
Chris
Open in new window