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