days of week

G

Gary

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
 
D

Dave Peterson

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display proper date on Saturday 1
if formula 1
Figuring out a lengthy formula. Probably quite simple... 3
Averageifs - criteria is cell is not blank 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Show other cell if blank 5
count days 3
days of the week 6

Top