combine dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help? lets say I have a date in 1 cell Example: 10-29-03 and I have a cell that I have added 120 days to that date and a cell that I have added 180 days. What I want to do is have a cell that combines both these cells with a start date and an end date can this be done?
 
Linda,

If the date in A1 is: 29-Oct-03

Put in say, B1:

="Start date: "&TEXT(A1+120,"dd-mmm-yy")&" End
date: "&TEXT(A1+180,"dd-mmm-yy")


B1 will return the text:

Start date: 26-Feb-04 End date: 26-Apr-04

--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik said:
-----Original Message-----
Click to expand...
Linda_jo said:
Help? lets say I have a date in 1 cell Example: 10-29-03
Click to expand...
and I have a cell that I have added 120 days to that date
and a cell that I have added 180 days. What I want to do
is have a cell that combines both these cells with a start
date and an end date can this be done?
 
Back
Top