I have an Excel report with several columns of information that I want to set up the headings with text and a calculated date using VBA to write the formulas for the headings. The fixed date in R3, for example, is 02-May-06 and has a date format. I want one of the headings (column N) to display "Days 1-30 (Mar 2006)". The following formula displays the correct date "Mar 2006":
When I try to join text to this formula, such as
the cell displays "(38778)".
I am looking for a way to display text and a formatted date in the same cell.
MTB: your solution, ="Days 1-" & TEXT(DATE(YEAR($R$3),MONTH($R$3)-1,0),"dd") & " (" & TEXT(DATE(YEAR($R$3),MONTH($R$3)-2,DAY($R$3)),"mmm yy") & ")" is just what was needed to display a calculated month and join it with text in a cell, and the result looks like this: Days 1-30 (Mar 06)
This is to create headings in 4 columns for 1-30 days, 31-60 days, 61-90 days and 91-120. These are just labels indicating how long a bill is overdue and they do not represent the number of calendar days.