concatenate values of two cells
It sounds like you want Concatenate the start and end date in one cell, as
text, when the start and end dates are dates, not text.
=CONCATENATE(TEXT(E1,"m/d/yyyy")," - ",TEXT(F1,"m/d/yyyy"))
where E1 is start date and F1 is end date.
Mike F
"ll" wrote in message
oups.com...
How do you go about setting the value of one cell equal to a text
string of the value of one cell, &, and the value of another cell?
Specifically, I'm trying to refer to the date values of my begin and
end dates on my timesheet.
Thanks,
Louis
|