Concatenate Text with Date plus an IF field that will include date

[maloney12]

Hi,
I have a start date and an end date. Sometimes the end date is blank. I want the end date to read Pres if there is no date.

=""&TEXT(E2,"yyyy")&" - "&IF(F2="","Pres",F2)

F2 is the end date - so it part way works: 2005 - Pres if F2 is blank. But if it isn't blank how can I get it to put the date field in to read:
2005 - 2014?

I tried =""&TEXT(E2,"yyyy")&" - "&IF(F2="","Pres",F2, "yyyy") - to many arguments.

Anyone that can help it would be very much appreciated!

Thank you!
Lori

 

[Weazel]

maybe something like...

=TEXT(E2,"yyy")&" - "&IF(F2="","Pres",TEXT(F2,"yyy")) ?

 

[JackDanIce]

Welcome to the board. You weren't far off, try:

=TEXT(E2,"YYYY") & " - " & IF(F2="","Pres",TEXT(F2,"YYYY"))

 

[maloney12]

Welcome to the board. You weren't far off, try:

=TEXT(E2,"YYYY") & " - " & IF(F2="","Pres",TEXT(F2,"YYYY"))

Thank you both for the quick replies! That works!