Truncate A Date to First of the Month
Writing by shivdev 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
- Add this post to
- Del.icio.us -
- Digg -
- -
- Tweet -
-
-
No Comments
No comments yet.
Leave a comment
You must be logged in to post a comment.