Formula to Get Day of Week....

[stlrain95]

I am currently using a VB form to insert data into an excel spreadsheet. I would like to take the date/time and find the day of the week. Once I have that day of the week, put the data into the day tab.

I am sure this can be done...but perhaps not hair pulling.

thank you,

 

[CassandraR]

Hi:

You might be looking for the

Weekday(date, [firstdayofweek])

function.

Cassie

 

[MichaelRed]

Use the ubiquitous {F1} (aka "Help) for the the term "Weekday" &/or search these fora for the same term.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[CCLINT]

IMO, rather use Weekday() function than using the Format(Date, "w&quot function.

There is also a WeekDayname() function which can be used as:
WeekDayname(Weekday(Date, True))

instead of Format(Date, "ddd&quot