Great reference for examples of formulas that you can use in MOSS2007 list columns.
http://usa1021.wss.bcentral.com/_vti_bin/help/1033/sts/html/EgForm.htm
Combine text with a date or time
Use the TEXT function and the ampersand (&) operator to do this task.
| Column1 | Column2 | Formula | Description |
|---|
| Billing Date | 5-Jun-2007 | ="Statement date: "&TEXT(Column2, "d-mmm-yyyy") | Combine text with a date (Statement date: 5-Jun-2007) |
| Billing Date | 5-Jun-2007 | =Column1&" "&TEXT(Column2, "mmm-dd-yyyy") | Combine text and date from difference columns into one column (Billing Date Jun-05-2007) |