| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
If a user inputs 2000-2001, or 2007-2008, is there a way to formulaically
have the cell underneath increase by one year? i.e., if in B2 the user input, say, 2005-2006, B3 would show 2006-2007 and B4 would show 2007-2008, etc. down the column? Thank you!  D |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
Try this:
=IF(B2="","",VALUE(LEFT(B2,4))+1 &"-"& VALUE(RIGHT(B2,4))+1) and copy down the column for as many as you need. Hope this helps. Pete On May 29, 3:16 pm, "StargateFanFromWork" <NoS...@NoJunk.com> wrote: > If a user inputs 2000-2001, or 2007-2008, is there a way to formulaically > have the cell underneath increase by one year? > > i.e., if in B2 the user input, say, 2005-2006, B3 would show 2006-2007 and > B4 would show 2007-2008, etc. down the column? > > Thank you! D |
|
|
|
|
|||
|
Guest
Posts: n/a
|
"Pete_UK" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)... > Try this: > > =IF(B2="","",VALUE(LEFT(B2,4))+1 &"-"& VALUE(RIGHT(B2,4))+1) > > and copy down the column for as many as you need. > > Hope this helps. > > Pete Seems to do the job just perfectly. Thanks! > On May 29, 3:16 pm, "StargateFanFromWork" <NoS...@NoJunk.com> wrote: >> If a user inputs 2000-2001, or 2007-2008, is there a way to formulaically >> have the cell underneath increase by one year? >> >> i.e., if in B2 the user input, say, 2005-2006, B3 would show 2006-2007 >> and >> B4 would show 2007-2008, etc. down the column? >> >> Thank you! D |
|
|
|
|
|||
|
Guest
Posts: n/a
|
You're welcome - thanks for taking the trouble to feed back.
Pete On May 29, 4:56 pm, "StargateFanFromWork" <NoS...@NoJunk.com> wrote: > "Pete_UK" <pashu...@auditel.net> wrote in message > > news:(E-Mail Removed)... > > > Try this: > > > =IF(B2="","",VALUE(LEFT(B2,4))+1 &"-"& VALUE(RIGHT(B2,4))+1) > > > and copy down the column for as many as you need. > > > Hope this helps. > > > Pete > > Seems to do the job just perfectly. Thanks! > > > > > On May 29, 3:16 pm, "StargateFanFromWork" <NoS...@NoJunk.com> wrote: > >> If a user inputs 2000-2001, or 2007-2008, is there a way to formulaically > >> have the cell underneath increase by one year? > > >> i.e., if in B2 the user input, say, 2005-2006, B3 would show 2006-2007 > >> and > >> B4 would show 2007-2008, etc. down the column? > > >> Thank you! D- Hide quoted text -> > - Show quoted text - |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| dd/MM/YYYY in SQL & Ctrl Panel but access read it as MM/dd/YYYY | =?Utf-8?B?U3VtbWVyQ29rZQ==?= | Microsoft Access Queries | 2 | 10th Sep 2007 06:17 AM |
| change birthday display from mm/dd/yyyy to HIDE the yyyy? | =?Utf-8?B?am9obnA=?= | Microsoft Excel Worksheet Functions | 1 | 9th May 2006 09:56 PM |
| How do I query a Date field (mm/dd/yyyy) by a Year (yyyy) value. | Wayne | Microsoft Access Queries | 2 | 23rd Feb 2006 12:24 AM |
| opening excel file -> date format problem: DD/MM/YYYY vs MM/DD/YYYY | yung | Microsoft Excel Programming | 2 | 18th Mar 2005 12:50 PM |
| Date format : field set to dd/mm/yyyy, but query wants mm/dd/yyyy | aa | Microsoft Access Database Table Design | 2 | 29th Dec 2003 10:53 AM |
