Truncate A Date to First of the Month

Writing by on Friday, 2 of November , 2007 at 2:33 pm

Want to convert 1/20/2007 to 1/1/2007 in Excel?
Use the DATE excel function.

=DATE(YEAR(A1),MONTH(A1),1)

Leave a comment

Category: Excel

No Comments

No comments yet.

Leave a comment

You must be logged in to post a comment.

Shivdev Kalambi's Blog

Shivdev Kalambi is a Software Development Manager, previously a Principal Software Engineer at ArcSight/HP. With over 16 years' experience in software development, he's worked on several technologies and played different roles and contributed to all phases of projects. Non-tech activies include Ping-pong, Rock Climbing and Yoga at PG, Golf, Skiing, Swimming & a beer enthusiast.