Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Stack Overflow for Teams is now called Stack Internal. Bring the best of human thought and AI automation together at your work.
Bring the best of human thought and AI automation together at your work. Learn more
Stack Internal
Knowledge at work
Bring the best of human thought and AI automation together at your work.
Last Datedate of the month (Worksthis works for leap year as well) QDate = August 2015 =DATE(YEAR(QDate),MONTH(QDate)+1,DAY(QDate))
QDate = August 2015
=DATE(YEAR(QDate),MONTH(QDate)+1,DAY(QDate))
Last Date of the month (Works for leap year as well) QDate = August 2015 =DATE(YEAR(QDate),MONTH(QDate)+1,DAY(QDate))
Last date of the month (this works for leap year as well)
