software

I am working on a large, multi-sheeted workbook. Many rows amp; colums.
Lots of data. QUESTION: to REPEAT a DATE across cells, amp; sheets (that is,
to change a date - say 11/20/2004 to 11/20/2005, what do I do?
I tried using quot;find/replacequot; (a very powerful tool), however, I ALSO
wanna be able to quot;changequot; either/both the MONTH/DAY in the date field.
I have already changed all the YEARS (2003 -gt; 2004; 2004 -gt; 2005);
but I want either a.) formula usage; or b.) quot;find/replacequot;. I tried to use
quot;wildcardsquot;, but all I got was 2857 find/replaces like this: FIND: 11/**/2004
amp; REPLACE w/: 11/20/2005, when the former was **=20. amp; I ended up
w/2857 quot;11/**/2005 s !!! TRUE. I admit I'm an idiot, but I'm getting
tired, now.
Any help would be appreciated. Thx.
--
Pennsylvania

Never mind; I used a Boolean formula intstead. Thx.
--
Pennsylvaniaquot;Pennsylvaniaquot; wrote:

gt; I am working on a large, multi-sheeted workbook. Many rows amp; colums.
gt; Lots of data. QUESTION: to REPEAT a DATE across cells, amp; sheets (that is,
gt; to change a date - say 11/20/2004 to 11/20/2005, what do I do?
gt; I tried using quot;find/replacequot; (a very powerful tool), however, I ALSO
gt; wanna be able to quot;changequot; either/both the MONTH/DAY in the date field.
gt; I have already changed all the YEARS (2003 -gt; 2004; 2004 -gt; 2005);
gt; but I want either a.) formula usage; or b.) quot;find/replacequot;. I tried to use
gt; quot;wildcardsquot;, but all I got was 2857 find/replaces like this: FIND: 11/**/2004
gt; amp; REPLACE w/: 11/20/2005, when the former was **=20. amp; I ended up
gt; w/2857 quot;11/**/2005 s !!! TRUE. I admit I'm an idiot, but I'm getting
gt; tired, now.
gt; Any help would be appreciated. Thx.
gt; --
gt; Pennsylvania