 |
 |
| About MrExcel |
| Consulting Services |
| Learn Excel Resources |
| Challenge of the Month |
| MrExcel Seminars |
| MrExcel Store |
| Podcast |
| Search |
| Contact |
| Home |
 |
Past Tip of the Day
|
|
Jorge asks "Please, how can I fill a column with the last date of the month, starting with the last date of one particular month ?. I've tried filling series, but if I start for instance with 30-june-2002, the following cell will be 30-july-2002 but not 31-july-2002 that is the one I need, and so on. Thank you," To do this you’ll have to use a formula. If the starting date (30-june-2002) is in A2, put this formula in A3 and drag down. =DATE(YEAR(A2),MONTH(A2)+2,0) MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.
|