ExcelBanter - TEXT date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - TEXT date (https://www.excelbanter.com/excel-discussion-misc-queries/119047-text-date.html)

Neil

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

Steve Yandl

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

Gary''s Student

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

All times are GMT +1. The time now is 05:28 AM.