Converting number dates to Day of Week

G

Guest

I have a table with a date column. You type the date manually for each new
record, for tracking purposes. The date format is 99/99/9999.

I would like to create a query that simply uses all the information from
this table, but add a column to the query where it converts the date to the
correct day of the week. In other words, if 5/17/06 is a Wednesday, I want
the formula column to show "'Wednesday".
 

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

Query from day of week 3
Day of week 6
Excel Forecasting Dates Out to the Day 3
report filter day of the week 2
Week, monthly, quarterly 2
Convert dates to "week beginning.." dates 4
Week number to Monday of week 3
Filter for Day of the Week 4

Top