Date formula to show date of tthe first day for current month and year

Topic Labels: Formulas
812 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there -

Looking for a way to have a formula show the first of the month for the current month and year. I.e. the formula fields says 2/1/2022 when it is Feb, then when it is March 3/1/2022 and so on…it would update on the first of each month

Any help out there?

2 Replies 2

This formula can be written a variety of ways, one of which is:


Thank you! Works just as I wished