In column B are dates displayed as dddd/mmmm/yyyy.

In column A are days of the week displayed as Mon, Tue, etc based on a
formula "=TEXT(B1,"ddd")".

The formula is ideal other than blank cells in column B return "Sat" in
corresponding column A cells. Is there a formula that would leave a cell
blank in A if there is no date yet entered in a corresponding cell in column
B?

Regards,
Gary

=if(b1="","",text(b1,"ddd")

Or you could just format the date column to include the day. Give it a custom
format of:

ddd dd/mm/yyyy
(or whatever you like)



Gary wrote:
>
> In column B are dates displayed as dddd/mmmm/yyyy.
>
> In column A are days of the week displayed as Mon, Tue, etc based on a
> formula "=TEXT(B1,"ddd")".
>
> The formula is ideal other than blank cells in column B return "Sat" in
> corresponding column A cells. Is there a formula that would leave a cell
> blank in A if there is no date yet entered in a corresponding cell in column
> B?
>
> Regards,
> Gary

--

Dave Peterson

Dave,

It worked ideal.

Thanks for the tip,
Gary

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> =if(b1="","",text(b1,"ddd")
>
> Or you could just format the date column to include the day. Give it a
> custom
> format of:
>
> ddd dd/mm/yyyy
> (or whatever you like)
>
>
>
> Gary wrote:
>>
>> In column B are dates displayed as dddd/mmmm/yyyy.
>>
>> In column A are days of the week displayed as Mon, Tue, etc based on a
>> formula "=TEXT(B1,"ddd")".
>>
>> The formula is ideal other than blank cells in column B return "Sat" in
>> corresponding column A cells. Is there a formula that would leave a cell
>> blank in A if there is no date yet entered in a corresponding cell in
>> column
>> B?
>>
>> Regards,
>> Gary
>
> --
>
> Dave Peterson