| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
finding the last day of the month
I have a spreadsheet that has a date column listing dates going back 3 years,
each month has about 50 line items with different days of the month, it there a way to create a new column that lists the last day of the month for each line item? For example if the date was August 9, 2007 the formula would return August 31,2007. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help finding the date of the last Saturday of a given month | Excel Worksheet Functions | |||
| Finding Particular Day of Month | Excel Worksheet Functions | |||
| Finding the last day of a month | Excel Discussion (Misc queries) | |||
| Finding the Sum of value each month | Excel Discussion (Misc queries) | |||
| Finding min and max date of a given month | Excel Worksheet Functions | |||
Threaded Mode
