MrExcel Publishing
Your One Stop for Excel Tips & Solutions

concatenate text w/ date


Posted by mcarter973 on April 26, 2001 6:18 AM

here's an example:

1.=CONCATENATE("Net Asset Value at"," ",TEXT(a3,"mmmm dd, yyyy"))

2.=CONCATENATE("Net Asset Value at"," ",TEXT(a3,"mmmm dd, yyyy"))

where 1. is the beginning date, 2. is the ending date and A3 is the link
to the ending date.

what string could i use for the beginning date? (right now i just use "minus 30" after A3 but
that only works with 30 days in the calendar month.


Posted by Mark W. on April 26, 2001 6:21 AM

=A3-DAY(A3)+1