Question about Business & Productivity Software
There is no function to do this as part of a whole suite of date manipulation functions, but I seem to have imagined that, as I couldn’t find. I was dreading having to do lots of nasty date arithmetic, but then I discovered that the zeroth day of a month is treated as the last day of the previous month! So the last day of the month for the date that’s in cell B3 is simply:
=DATE(YEAR(B3), MONTH(B3)+1, 0)
It even works across year boundaries, so DATE(2004, 13, 0) really does give
Posted on Mar 11, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jun 23, 2011 | Microsoft Excel for PC
Apr 06, 2010 | Microsoft Office Excel 2003 for PC
Aug 23, 2009 | Microsoft Excel for PC
May 31, 2009 | Microsoft Office Excel 2003 for PC
Mar 15, 2009 | Microsoft Office Excel 2003 for PC
Feb 22, 2009 | Microsoft Business & Productivity Software
Jan 30, 2009 | Microsoft Excel for PC
Aug 25, 2008 | Microsoft Office Professional 2007:...
Mar 06, 2008 | Microsoft Excel for PC
Jan 16, 2017 | The Business & Productivity Software
99 people viewed this question
Usually answered in minutes!