changing dates in a date formated column ?

Posted to microsoft.public.excel.misc

Tim[_7_]

external usenet poster

Posts: 11

changing dates in a date formated column ?

Is there a function that can change the date in a column of dates by
increasing the day in month/day/year format by the value of a number
(4,12,8...etc) in the adjoining column.

If the date is 01/20/07 and the adjoining column is 7...is there a formula
that will auto modify it with in a new column with a value of 01/27/07 and
so on ?

Thanks, Tin

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
How do I add 24 hours to a date and time value formated cell?	kknight79558	Excel Discussion (Misc queries)	4	August 20th 07 07:20 PM
Dates won't stay formated	marketerinco	Excel Discussion (Misc queries)	12	November 13th 06 02:47 AM
Retrieve specific date from one row of one column that is changing	lpdc	Excel Worksheet Functions	2	June 14th 06 12:33 AM
fields formated as 3-8-18 autoformatting to date on when exported	Angel	Excel Discussion (Misc queries)	2	May 19th 06 06:52 PM
Matching 2 "dates" that are formated differently	carl	Excel Worksheet Functions	3	December 3rd 04 07:35 PM

All times are GMT +1. The time now is 11:16 AM.

Menu

About Us