| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Auto_Open() How to show prior Monday?
This code gets me the 1st day of the current workweek. I need to edit it to
get the 1st day of the previous workweek. Sub Auto_Open() ' Enter the prior Monday Set StartDay = Sheets("SamB").Range("StartDay") StartDay.Value = Date Do Until Weekday(StartDay) = 2 StartDay.Value = StartDay.Value - 1 Loop End Sub I would appreciate your help. Thanks, Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show macro security setting in a cell | Excel Worksheet Functions | |||
| pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
| UDF and Calculation tree | Links and Linking in Excel | |||
| hide column but show chart | Charts and Charting in Excel | |||
| Show a date based on today | Excel Worksheet Functions | |||
Threaded Mode
