days and dates

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

Guest

hi
I am trying to make up a spreadsheet for a room booking system that states
both the day and date ie. Monday 1 January 2007. How do I add a formula that
will automatically change the day and date and omit weekends?
 
Let's say the entered date is in A1. In another cell enter:

=IF(OR(WEEKDAY(A1)=7,WEEKDAY(A1)=1),"",A1)

and format that cell as custom
dddd dd mmmm yyyy

So if the entered date is a weekend date the formula returns a blank.
 

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

days and dates 6
date to show then end of the week 2
Excel Forecasting Dates Out to the Day 3
identifying the next working day after weekends and/or holidays 2
Excel Vba to change displayed year automatically. 14
Outlook: Meeting recurrence every 6 WEEK days AND exclude weekends 0
I need help to make a not-so-easy AVERAGE formula! 4
Need help creating a simple (?) SUM formula! 4

Back
Top