| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want last days of the month in cells A1-A12
How do I tell Excel 2007 to calculate the last day of the month
.....Lisa |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want last days of the month in cells A1-A12
EOMONTH function.
-- Gnothi se auton. "hamiltoncruiser" wrote: How do I tell Excel 2007 to calculate the last day of the month .....Lisa |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want last days of the month in cells A1-A12
On Thu, 22 Nov 2007 07:33:48 -0800 (PST), hamiltoncruiser
wrote: How do I tell Excel 2007 to calculate the last day of the month ....Lisa =DATE(year(dt),month(dt)+1,0) or =EOMONTH(dt,0) dt can be an actual date, or a reference to a cell containing a date. --ron |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want last days of the month in cells A1-A12
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in. -- regards from Brazil Thanks in advance for your feedback. Marcelo "hamiltoncruiser" escreveu: How do I tell Excel 2007 to calculate the last day of the month .....Lisa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of days in month counted from shortened name of month & yea | Excel Worksheet Functions | |||
| Days per month for calculating storage days | Excel Worksheet Functions | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| Dates - Several Days In a month to month only | Excel Discussion (Misc queries) | |||
Linear Mode
