MATCHING DATE TO A WEEKDAY

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there an easy way to indentify the weekday from a specfic date rather than
go down the lookup route
 
Use the text formula ie in cell A2 type =TEXT(A1,"DDDD""). Converts the date
in A1 to the full name of the day. If you only use "DDD" it will abreviate
the day name as Tue instead of Tuesday. Formula also works for Months using
"MMM"
 
Hi Stuart

Format>Cells>Number>Custom mmm will give Mon mmmm will give Monday
Either apply this to your cell with the date (A1), or to another cell
which has the formula =A1
 
You must log in or register to reply here.

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

Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
Sumif weekday 3
Generate Payment Due Date to exclude Weekends and Public Holiday 4
Round dates to weekdays 8
Re: How can I count the number of SATURDAYS in a month? 0
How to format cell to get first capital letter? 5
Help with Excel 2007 COUNTIFS! 0
Use array/braces **WITHIN** a formula? 3

Back
Top