Date and Weekday Formula

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

Hi.

I am using the following formual to find dates (9days after a specific
date).
=IF(G4>0,INDEX(DATES,MATCH(G4,DATES,1)+9)," ")

What I am needing is;

Instead of just:

the date that is provided in the DATES column.

7/17/07

I need the weekday of the date in front.

Tue 7/17/07

If not with this one, is there to include the day of the week into a
formula?


Thanx
 
How about just giving that cell a custom format:

Select the cell(s)
format|cells|Number tab|Custom category
ddd m/d/yy

=====
And if you don't have any gaps in your dates range, couldn't you just add 9 to
the date?

=if(g4>0,g4+9,"")

ps.

Returning a string like " " (with that space character) is a problem just
waiting to happen. I'd return "" if I were you.
 
Just format as ddd m/d/yy

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top