Posted to microsoft.public.excel.misc

delete automatically delete automatically is offline

external usenet poster

Posts: 37

Is there a way to change all dates in a spread sheet

I have a spread sheet with dates for the whole year of 2006. Exmaple I have
1/1/06 thru 1/15/06 in the first 14 rows. Then rows 15 thru 20 have other
data. Then start with 1/16/06 thru 1/29/06 then more data. How can I changed
the dates to the right dates of 2007 without gong to each block of dates.

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
Summary sheet showing holiday dates taken	louiscourtney	Excel Worksheet Functions	4	December 19th 06 03:04 PM
Want cell ref. to change after sort in other sheet	Bullfn33	Excel Discussion (Misc queries)	1	August 6th 06 05:48 PM
Macro to change data in a sheet	Diana	Excel Discussion (Misc queries)	1	April 28th 06 08:01 PM
Change scales from reference cells value for a chart in a separate sheet	ers	Charts and Charting in Excel	4	April 2nd 06 07:00 PM
when i move or copy a sheet, dates change by one day??	Devo	Excel Discussion (Misc queries)	2	February 5th 06 03:01 PM

All times are GMT +1. The time now is 03:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us