Date and Weekday Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J.W. Aldridge - 17 Jul 2007 20:04 GMT

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

Reply to this Message

Dave Peterson - 17 Jul 2007 20:18 GMT

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.

> Hi.
>
[quoted text clipped - 18 lines]
>
> Thanx

Signature

Dave Peterson

Reply to this Message

Bob Phillips - 17 Jul 2007 20:22 GMT

Just format as ddd m/d/yy

Signature

HTH

Bob

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

> Hi.
>
[quoted text clipped - 18 lines]
>
> Thanx

Reply to this Message