Concatenate-Dates

R

reno

want to insert two dates into one cell as a heading on a form for someone to
full out. have set up lookup table for 52 week year, with week begining and
week ending dates. would type in say week 43 and deisre to get 10/24/2004
and 10/31/04 and concatenate to fit into one cell. it returns the serial
numbers for the dates.
any suggestions?
 
B

Bob Phillips

=TEXT(A1,"dd mmm yyyy") & " " & TEXT(A2,"dd mmm yyyy")

where A1 and A2 hold the dates
 
R

Ron Rosenfeld

want to insert two dates into one cell as a heading on a form for someone to
full out. have set up lookup table for 52 week year, with week begining and
week ending dates. would type in say week 43 and deisre to get 10/24/2004
and 10/31/04 and concatenate to fit into one cell. it returns the serial
numbers for the dates.
any suggestions?
Click to expand...

=TEXT(VLOOKUP(weeknumber,tbl,2),"mm/dd/yyyy") & " - " &
TEXT(VLOOKUP(weeknumber,tbl,3),"mm/dd/yyyy")




--ron
 
M

mzehr

Hi,
Try the following, assuming that the value to be looked up is A1 and the
lookup table is c1:d52 (if not change accordingly):

=IF(ISERROR(VLOOKUP(A1,C1:D52,2,FALSE)),"",TEXT(VLOOKUP(A1,C1:D52,2,FALSE),"MM/DD/YYYY")&" and "&TEXT((VLOOKUP(A1,C1:D52,2,FALSE)+7),"MM/DD/YYYY"))
 
R

reno

sorry, doesn't take into account the lookup functioin, others in the thread
do, thanks anyway
 
Top