Date verification

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

Guest

I have an input cell date that must be a Sunday
The next colunm over shows this date as a day of the week
I want the second cell to show "Wrong Date" if the date entered is not a
Sunday
 
=if(weekday(a1)=1,text(a1,"dddd"),"Wrong Date")


I have an input cell date that must be a Sunday
The next colunm over shows this date as a day of the week
I want the second cell to show "Wrong Date" if the date entered is not a
Sunday
Click to expand...
 
Format|conditional formatting:

Cell value is: Equal to: Wrong date

Excel will change that last string to: ="wrong date"
 

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

Can I create my own date showing day of week plus date? 2
CALENDAR CREATION 1
adding days from one cell with a date in it to another cell 3
Conditional Formatting Dates 5
If weekend date display previous Friday date 4
Access Property sheet data missing also syntax 0
Calculating dates to include Saturdays but not Sundays 1
formual to determine if date falls on weekend, adjust date to Mond 4

Back
Top