Formula to maintain 1st day of month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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


--ron
 
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Input Fiscal Year. 1
Excel Message box with days of month & date. 1
Showing first day of the next month in a column ... 7
Subtracting months formula 5
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
Comparison bar graphs 2
Complicated Date Calculation needed 5
Summing monthly data from weekly data input, with a twist 4

Back
Top