| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates on a worksheet
I want to be able to input a date and have the spreadsheet automatically list
the proceeding months with the last day of the month. In other words, if in cell A1 I enter 01/31/2008, I want to automatically see 02/28/2008 in A2, then 03/31/2008 in A3, etc. If I key in 07/31/2008 in A1, I'd like to see 08/31/2008 in A2, 09/30,2008 in A3, etc. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dates on a worksheet
Hi
=DATE(YEAR(A1),MONTH(A1)+2,0) =DATE(YEAR(A1),MONTH(A1)+4,0) etc. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "climber322" wrote in message ... I want to be able to input a date and have the spreadsheet automatically list the proceeding months with the last day of the month. In other words, if in cell A1 I enter 01/31/2008, I want to automatically see 02/28/2008 in A2, then 03/31/2008 in A3, etc. If I key in 07/31/2008 in A1, I'd like to see 08/31/2008 in A2, 09/30,2008 in A3, etc. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dates on a worksheet
Great! Thanks very much.
"Arvi Laanemets" wrote: Hi =DATE(YEAR(A1),MONTH(A1)+2,0) =DATE(YEAR(A1),MONTH(A1)+4,0) etc. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "climber322" wrote in message ... I want to be able to input a date and have the spreadsheet automatically list the proceeding months with the last day of the month. In other words, if in cell A1 I enter 01/31/2008, I want to automatically see 02/28/2008 in A2, then 03/31/2008 in A3, etc. If I key in 07/31/2008 in A1, I'd like to see 08/31/2008 in A2, 09/30,2008 in A3, etc. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting dates in a worksheet | Excel Discussion (Misc queries) | |||
| Dates period from master worksheet to another worksheet | Excel Discussion (Misc queries) | |||
| Worksheet Tabs Names as Dates | Excel Worksheet Functions | |||
| How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions | |||
| worksheet functions with dates | Excel Worksheet Functions | |||
Linear Mode
