A focus on improvement- in self, in business, in life
December 20, 2010 Leave a comment
Here’s a common problem. You need to create a column with the last day of a given month, converting another date in the row/record. Below accomplishes the trick:
DATE(YEAR(B5),MONTH(B5)+1,1)-1
where the cell, B5, contains the date you are converting.
I am an executive finance professional with a love for process and application development (MS Access, Excel, Quickbooks), mostly as it relates to Accounting and Business Functions. I also love to write and share ideas with other people in this world. I'm an admitted Gym Rat who works out excessively. The best summation of me is that I love to teach and to learn.
BobbyBluford.com 