Date Problem

J

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
 
D

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?
Click to expand...

Hi Jim,

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

Cheers!
 
Top