Date Problem

[Jim Sutton]

--
="Billing Month:"& " "&TEXT(AT91,"mmm-yy")
Can I add to this Formula so as if there is no date in AT91 I get a blank "
" cell?

TIA......Jim

 

[Domenic]

="Billing Month:"& " "&TEXT(AT91,"mmm-yy")
Can I add to this Formula so as if there is no date in AT91 I get a blank "
" cell?

Hi Jim,

=IF(AT91="","","Billing Month:"&" "&TEXT(AT91,"mmm-yy"))

Cheers!

 

[Vasant Nanavati]

=IF(AT91="","","Billing Month: "&TEXT(AT91,"mmm-yy"))

 

[Jim Sutton]

Thanks for the help worked great.. Jim

=IF(AT91="","","Billing Month: "&TEXT(AT91,"mmm-yy"))

--

Vasant


blank