Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you change the year but not the month automatically?
One of the columns in my spreadsheet is:
Jan-06 Feb-06 March-06 (Etc) Is there any way to change the year for Jan- 06 (say to Jan- 07) and it will automatically change the rest of the months year to 07? Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you change the year but not the month automatically?
=date(year(a1),month(a1)+1,1)
Format the way you want. And drag across. Autumn Dreams wrote: One of the columns in my spreadsheet is: Jan-06 Feb-06 March-06 (Etc) Is there any way to change the year for Jan- 06 (say to Jan- 07) and it will automatically change the rest of the months year to 07? Thank you. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you change the year but not the month automatically?
Hi, You can use this criterion. Assuming your control date is in B2 and your column header is Date Then C1:E1 : Date C2: ="="&DATE(YEAR(B2),MONTH(B2),1) D2: ="<"&DATE(YEAR(B2),MONTH(B2) + 1, 1) E2: ="<"&B2 Then specify C1:E2 as the criterion. -- KellTainer ------------------------------------------------------------------------ KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322 View this thread: http://www.excelforum.com/showthread...hreadid=546280 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you change the year but not the month automatically?
Wrong reply to wrong post :( -- KellTainer ------------------------------------------------------------------------ KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322 View this thread: http://www.excelforum.com/showthread...hreadid=546280 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create charts that change source data automatically? | Charts and Charting in Excel | |||
Format date with just month and year | Excel Discussion (Misc queries) | |||
worksheet tabs automatically change? | Excel Worksheet Functions | |||
automatically update chart plotting current month and previous 6 | Charts and Charting in Excel | |||
Insert Month and Year in my worksheet | Excel Worksheet Functions |