Forum Discussion

Kevin2069's avatar
Kevin2069
Copper Contributor
Dec 22, 2022
Solved

[Solved] Macro Formula to set cell to Start of Current Week

Edit: Thank you, Quadruple_Pawn, for the help. I am trying to make a macro button to set a cell to the Monday of the week I am on. Currently the output is getting the start of the week of Jan,1900...
excel
Formulas and Functions
Macros and VBA
  • OliverScheurich's avatar
    OliverScheurich
    Dec 22, 2022

    Kevin2069 

    Sub StartWeek()
    Range("C4").Value = Date - Weekday(Date) + 2
    End Sub

     

    You can try this code.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Dec 22, 2022

Kevin2069 

Sub StartWeek()
Range("C4").Value = Date - Weekday(Date) + 2
End Sub

 

You can try this code.

Resources