| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Finding the last day of a month
i know how to find the first day of a month but how can i find the last day of a month? October 2005 First day is Sat 1st. I also need the formula to find Mon 31st. Thanks -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=477256 |
|
#2
|
|||
|
|||
|
Finding the last day of a month
The 0th day of the next month is the last day of the current
month. Therefore, you can use a formula like =DATE(2005,11,0) to return the last day in October, 2005. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "comotoman" wrote in message ... i know how to find the first day of a month but how can i find the last day of a month? October 2005 First day is Sat 1st. I also need the formula to find Mon 31st. Thanks -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=477256 |
|
#3
|
|||
|
|||
|
Finding the last day of a month
If the date is in A1, then enter:
=DATE(YEAR(A1),MONTH(A1)+1,1)-1 in a cell to get the last day of that month -- Gary''s Student "comotoman" wrote: i know how to find the first day of a month but how can i find the last day of a month? October 2005 First day is Sat 1st. I also need the formula to find Mon 31st. Thanks -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=477256 |
|
#4
|
|||
|
|||
|
Finding the last day of a month
Or just:
=DATE(YEAR(A1),MONTH(A1)+1,0) Gary''s Student wrote: If the date is in A1, then enter: =DATE(YEAR(A1),MONTH(A1)+1,1)-1 in a cell to get the last day of that month -- Gary''s Student "comotoman" wrote: i know how to find the first day of a month but how can i find the last day of a month? October 2005 First day is Sat 1st. I also need the formula to find Mon 31st. Thanks -- comotoman ------------------------------------------------------------------------ comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292 View this thread: http://www.excelforum.com/showthread...hreadid=477256 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding people born in a given month or after a given year | Excel Worksheet Functions | |||
| Finding the Sum of value each month | Excel Discussion (Misc queries) | |||
| Finding min and max date of a given month | Excel Worksheet Functions | |||
| Add one month to the previuos month | Excel Discussion (Misc queries) | |||
| Month Year Date Format | Excel Worksheet Functions | |||
Linear Mode
