Formula for first day of month

R

Rheyjune

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

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

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

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