Posted to microsoft.public.excel.programming

EllenM

external usenet poster

Posts: 78

Update Timecard to new year

Hello,
I'd like to update a time card file to the 2008. It contains 26 worksheets,
each worksheet contains 14 dates.

For example 1/2/07 would become 1/1/08. For dates after Feb 28th, for
example 3/5/07 would become 3/3/08.

Is there a formula that would make these conversions? Sounds like I'd need
one for before Feb 28th and a second for after Feb 28th.

Thanks in advance.

Ellen

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Replace update year in date	Jeff C	Excel Discussion (Misc queries)	6	April 28th 08 10:38 PM
Date question? update year.	Jman	Excel Worksheet Functions	7	April 2nd 08 06:47 AM
timecard	vdmbqb	Excel Discussion (Misc queries)	1	February 26th 08 01:26 AM
Timecard	Michaela	Excel Discussion (Misc queries)	6	January 3rd 06 01:50 PM
automatically update WordArt when calandar year is changed	W.J.Surrarrer	Excel Programming	0	May 16th 04 04:15 AM

All times are GMT +1. The time now is 08:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us