Formula for first day of month

[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.

 

[Steve Schapel]

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.

 

[Michael Bednarek]

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.

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