| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to hide day
I have this equation.
=Text(f1,"DDDD") Which comes out as 3/1/08 Thursday. How do I get it to come up blank till I put in a date. At the moment it comes up like this. 3/1/08 Thursday Friday Friday Thanks in advance Larry |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to hide day
Hmmm...
To answer your question, try it like this: =IF(F1="","",TEXT(F1,"dddd")) You must be using a date format of d/m/yy. Also, you must be using the 1904 date system. Using the default 1900 date system an empty cell will evaluate to weekday Saturday. Using the 1904 system an empty cell evaluates to weekday Friday. -- Biff Microsoft Excel MVP "sureshift" wrote in message ... I have this equation. =Text(f1,"DDDD") Which comes out as 3/1/08 Thursday. How do I get it to come up blank till I put in a date. At the moment it comes up like this. 3/1/08 Thursday Friday Friday Thanks in advance Larry |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to hide day
Try this, im assuming you are using that formula and dragging it down across
multiple rows... so in F1 put the formula =IF(OR(F1=0,F1=""),"",TEXT(F1,"dddd")) Then drag and drop that formula. "sureshift" wrote: I have this equation. =Text(f1,"DDDD") Which comes out as 3/1/08 Thursday. How do I get it to come up blank till I put in a date. At the moment it comes up like this. 3/1/08 Thursday Friday Friday Thanks in advance Larry |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to hide day
=IF(F1="","",TEXT(F1,"DDDD"))
BTW "DDDD" will show Thursday only If you want 3/1/08 Thursday, use "d/m/yy DDDD" Gord Dibben MS Excel MVP On Fri, 8 Feb 2008 16:00:05 +1100, "sureshift" wrote: I have this equation. =Text(f1,"DDDD") Which comes out as 3/1/08 Thursday. How do I get it to come up blank till I put in a date. At the moment it comes up like this. 3/1/08 Thursday Friday Friday Thanks in advance Larry |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to hide day
Using the default 1900 date system
That would be for Wintel machines. I guess the 1904 date system is the default for Macs. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Hmmm... To answer your question, try it like this: =IF(F1="","",TEXT(F1,"dddd")) You must be using a date format of d/m/yy. Also, you must be using the 1904 date system. Using the default 1900 date system an empty cell will evaluate to weekday Saturday. Using the 1904 system an empty cell evaluates to weekday Friday. -- Biff Microsoft Excel MVP "sureshift" wrote in message ... I have this equation. =Text(f1,"DDDD") Which comes out as 3/1/08 Thursday. How do I get it to come up blank till I put in a date. At the moment it comes up like this. 3/1/08 Thursday Friday Friday Thanks in advance Larry |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to hide day
Thanks for your help it worked..
"sureshift" wrote in message ... I have this equation. =Text(f1,"DDDD") Which comes out as 3/1/08 Thursday. How do I get it to come up blank till I put in a date. At the moment it comes up like this. 3/1/08 Thursday Friday Friday Thanks in advance Larry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Unhide Hide again | New Users to Excel | |||
| Hide #N/A | Excel Discussion (Misc queries) | |||
| hide #VALUE! | Excel Worksheet Functions | |||
| How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) | |||
| how to hide #N/A's? | Excel Worksheet Functions | |||
Linear Mode
