software

I have a list of birthdays formulated 8/12/05
I want to change all the dates to next year i.e. 8/12/06

oldjay
You could use a formula:

=date(year(a1) 1,month(a1),day(a1))
Oldjay wrote:
gt;
gt; I have a list of birthdays formulated 8/12/05
gt; I want to change all the dates to next year i.e. 8/12/06
gt;
gt; oldjay

--

Dave Peterson

Or, for a quot;quick and dirtyquot; solution
Ctrl h to bring up Find and Replace
Find What/2005
Replace with/2006
Replace all

Regards

Roger GovierDave Peterson wrote:
gt; You could use a formula:
gt;
gt; =date(year(a1) 1,month(a1),day(a1))
gt;
gt;
gt;
gt; Oldjay wrote:
gt;
gt;gt;I have a list of birthdays formulated 8/12/05
gt;gt;I want to change all the dates to next year i.e. 8/12/06
gt;gt;
gt;gt;oldjay
gt;
gt;