Question about Computers & Internet
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 Technician 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 repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
May 26, 2017 | The Computers & Internet
Mar 01, 2017 | Microsoft Excel Mac for Mac
Dec 19, 2010 | Watches
Apr 17, 2017 | Microsoft Visual Basic 6.0 for PC
Mar 15, 2009 | Microsoft Office Excel 2003 for PC
Feb 17, 2009 | Microsoft Computers & Internet
Jan 30, 2009 | Microsoft Excel for PC
Aug 25, 2008 | Microsoft Office Professional 2007:...
Jun 27, 2008 | Excel (SS8SATAS5128400R)
Mar 06, 2008 | Microsoft Excel for PC
100 people viewed this question
Usually answered in minutes!