| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show day or empty cell
Hello,
Im using the formula =TEXT(A1, "ddd") to show the day from a date. How can I make it show an empty cell if there is nothing in cell A1? Sorry for the simply question, I'm new to this! Many thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show day or empty cell
try,
=IF(A1="","",TEXT(A1, "ddd")) Mike "KrisP" wrote: Hello, Im using the formula =TEXT(A1, "ddd") to show the day from a date. How can I make it show an empty cell if there is nothing in cell A1? Sorry for the simply question, I'm new to this! Many thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show day or empty cell
=if(A1<"",TEXT(A1, "ddd"),"")
"KrisP" wrote: Hello, Im using the formula =TEXT(A1, "ddd") to show the day from a date. How can I make it show an empty cell if there is nothing in cell A1? Sorry for the simply question, I'm new to this! Many thanks in advance |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show day or empty cell
You may wish to consider this formula instead of what you are using. It has
the advantage of being easier to perform calculations on =IF(A1="","",WEEKDAY(A1)) Mike "Mike H" wrote: try, =IF(A1="","",TEXT(A1, "ddd")) Mike "KrisP" wrote: Hello, Im using the formula =TEXT(A1, "ddd") to show the day from a date. How can I make it show an empty cell if there is nothing in cell A1? Sorry for the simply question, I'm new to this! Many thanks in advance |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show day or empty cell
Thanks to both of you, thats great.
"KrisP" wrote: Hello, Im using the formula =TEXT(A1, "ddd") to show the day from a date. How can I make it show an empty cell if there is nothing in cell A1? Sorry for the simply question, I'm new to this! Many thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show cell empty when 0 | Excel Discussion (Misc queries) | |||
| Lookup to Show Empty Cell | Excel Worksheet Functions | |||
| using a vlookup, can i use isblank to show an empty cell | Excel Worksheet Functions | |||
| show 0.00 if referenced cell is empty | Excel Worksheet Functions | |||
| Using if function to show blank when cell in other sheet is empty | Excel Worksheet Functions | |||
Linear Mode
