Formula to maintain 1st day of month

[Rheyjune]

What is the formula to make a cell always post the 1st day of the month.
For instance.. Its July and cell a1 has 07/01/2006. when it becomes August I
want that cell to auto change to 08/01/2006.

 

[bobocat]

=date(year(today()),month(today()),1)

 

[김훈ê·]

Thanks

bobocat 작성:

=date(year(today()),month(today()),1)

 

[김훈ê·]

Thanks

bobocat 작성:

=date(year(today()),month(today()),1)

 

[Ron Rosenfeld]

What is the formula to make a cell always post the 1st day of the month.
For instance.. Its July and cell a1 has 07/01/2006. when it becomes August I
want that cell to auto change to 08/01/2006.

=TODAY()-DAY(TODAY())+1


--ron

 

[Dave Peterson]

One more:

=A1-DAY(A1)+1

What is the formula to make a cell always post the 1st day of the month.
For instance.. Its July and cell a1 has 07/01/2006. when it becomes August I
want that cell to auto change to 08/01/2006.

 

[Dave Peterson]

Oops. I didn't see Ron's better answer.

One more:

=A1-DAY(A1)+1