| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TEXT date
i have a formula that returns the day of a inoutted date.
=TEXT(f1,"dddd") it works fine except for it will return a "saturday" if the cell is blank. How can i adapt it to ignore the blank cell? Many thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TEXT date
=IF(ISBLANK(F1),"",TEXT(F1,"dddd"))
Steve "Neil" wrote in message ... i have a formula that returns the day of a inoutted date. =TEXT(f1,"dddd") it works fine except for it will return a "saturday" if the cell is blank. How can i adapt it to ignore the blank cell? Many thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
TEXT date
=IF(WEEKDAY(F1)=7,"",TEXT(F1,"dddd"))
-- Gary's Student "Neil" wrote: i have a formula that returns the day of a inoutted date. =TEXT(f1,"dddd") it works fine except for it will return a "saturday" if the cell is blank. How can i adapt it to ignore the blank cell? Many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| About Text to Date | Excel Discussion (Misc queries) | |||
| turn off convert text to date (i.e. 4-9 to April 9, 2006) | Excel Worksheet Functions | |||
| How do I grab the date from a text string? | Excel Worksheet Functions | |||
| Macro to convert text to date | Excel Worksheet Functions | |||
| EXTRACT TEXT FROM A DATE | Excel Worksheet Functions | |||
Linear Mode
