Entering specific data in cells.

G

Gunjani

I have a column formatted in date form. I want to ensure that when a
date is inputted into that column it can only represent a date which
falls on a Saturday otherwise it will display a sign representing it is
not correct data. Any suggestions please.
 
F

Frank Kabel

Hi
- select the cell. e.g. cell B1
- goto 'Data - Validation' and choose 'Custom'
- enter the following formula
=WEEKDAY(B1)=6
 
G

Gunjani

Hi
- select the cell. e.g. cell B1
- goto 'Data - Validation' and choose 'Custom'
- enter the following formula
=WEEKDAY(B1)=6
Click to expand...
Doesn't work!
--
Many Thanks

Gunjani
Stock up and save. Limit: one. =3F.Actual Ad in
newspapers:
 
G

Gunjani

Typo Frank:

=WEEKDAY(B1,2)=6
Click to expand...
Thanks... can u just explain what the difference between the above and
the original =weekday(B1)=6 and also while u r there looking at the help
file on it there is the other option of =weekday(b1,3) but I could not
see the reason/logic?
--
Many Thanks

Gunjani
"In ancient Jewish tradition, a fetus does not becomes
viable until it completes medical school."
 
F

Frank Kabel

Hi
the second parameter indicates how to interpret the weekday numbering.
- second parameter = 1 or no second parameter: Sunday=1,
Monday=2,...,Saturday=7
- second parameter = 2: Monday=1, Tuesday=2,..,Sunday=7
- second parameter = 3: Monday=0, Tuesday=1,..,Sunday=6

So you could use one of the following formulas (they all will work):
=WEEKDAY(B1)=7
=WEEKDAY(B1,1)=7
=WEEKDAY(B1,2)=6
=WEEKDAY(B1,3)=5
 
G

Gunjani

Hi
the second parameter indicates how to interpret the weekday numbering.
- second parameter = 1 or no second parameter: Sunday=1,
Monday=2,...,Saturday=7
- second parameter = 2: Monday=1, Tuesday=2,..,Sunday=7
- second parameter = 3: Monday=0, Tuesday=1,..,Sunday=6

So you could use one of the following formulas (they all will work):
=WEEKDAY(B1)=7
=WEEKDAY(B1,1)=7
=WEEKDAY(B1,2)=6
=WEEKDAY(B1,3)=5
Click to expand...
Thank U

--
Many Thanks

Gunjani
34% of those who voted Republican in the last election
believe Forrest Gump is a documentary.
-- TV Nation Poll
 
A

AlfD

Gunjani:

I do not have any opinion on your programming problems, but I do find
racist jokes unacceptable in your tag line.

BTW: I'm not Jewish: I'm not anything.

Alf
 
Top