Default date 01/00/00

pouliotg

New Member
Joined
Nov 28, 2004
Messages
34
I have multiple worksheet that contains data such as Order Date, Ship Date and Invoice Date.

By default if my orders has not yet shipped or Billed the default showing is 01/00/00 for the date. I would like to translate that 01/00/00 to "Not Shipped" or "Not Bill".

Thanks
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,119,268
Messages
5,577,102
Members
412,768
Latest member
klig
Top