Try this:

=IF(A4="","EMPTY",IF(J1D1,"Expired
"&TEXT(DATE(YEAR(D4),MONTH(D4),DAY(D4)),"mmm-
yy"),DATE(YEAR(D4),MONTH(D4),DAY(D4))))

Hope this helps.

Pete

On Nov 8, 9:22 am, curiosity_killed_the_cat
wrote:
I have the following formula

=IF(A4="","EMPTY",IF(J1D1,"Expired
"&DATE(YEAR(D4),MONTH(D4),DAY(D4)),DATE(YEAR(D4),M ONTH(D4),DAY(D4))))

This is used to name the work sheet. When false is the result it returns the
date as mmm-yyyy which in turn names the sheet using a macro, and it works
fine.

The true result works, almost, it returns "Expired+the date as a serial #",
minus the quotes, and no matter what I do I can't get it to return "Expired
mmm-yyyy". Is it possible to get the false result as "Expired mmm-yyyy"
instead of the serial date?

J1 has the today() formula
D1 is a date entered by the user in dd/mm/yy format

Hope I made sense

Thanks