Concatenate-Dates

[Guest]

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?

 

[Bob Phillips]

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

where A1 and A2 hold the dates

 

[nika]

Assuming your dates are in A3 and A4 try this =A3&" "&A

 

[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?

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




--ron

 

[Guest]

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,C152,2,FALSE)),"",TEXT(VLOOKUP(A1,C152,2,FALSE),"MM/DD/YYYY")&" and "&TEXT((VLOOKUP(A1,C152,2,FALSE)+7),"MM/DD/YYYY"))

 

[Guest]

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

 

[Guest]

seems to work, could not figure out the text function
thanks

 

[Guest]

perfect with the iserror added, nearly foolproof now
thanks

 

[Guest]

thanks seems to work, will add the vlookup and go from there

 

[Myrna Larson]

TEXT is pretty well explained in Help.

seems to work, could not figure out the text function
thanks