Formula for first day of month

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

Guest

Could some one inform me what the formula is to make a cell always post the
first day of the current month?
For instance Collumn A has the 30/31 days listed for the current month.
When the month ends I would like cell A1 to automatically change to the 1st
day of the current month.
 
Rheyjune,

The focus of this newsgroup is macros in Access, the database product.
Sounds like your question relates to a spreadsheet, maybe Excel. If so,
you will have better chance of a good answer in an Excel newsgroup. Thanks.
 
Could some one inform me what the formula is to make a cell always post the
first day of the current month?
For instance Collumn A has the 30/31 days listed for the current month.
When the month ends I would like cell A1 to automatically change to the 1st
day of the current month.
Click to expand...

Try this in A1: =DATE(YEAR(NOW()),MONTH(NOW()),1)
 
Back
Top