Date Problem

  • Thread starter Thread starter Jim Sutton
  • Start date Start date
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
 
="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!
 
Back
Top