Entering specific data in cells.

[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.

 

[Frank Kabel]

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

 

[Ragdyer]

Use <Data> <Validation>
Choose "custom", and enter this formula:

=WEEKDAY(A1)=7

 

[Ragdyer]

Typo Frank:

=WEEKDAY(B1,2)=6

 

[Frank Kabel]

Hi
correct. Though I originally meant:
=WEEKDAY(B1)=7

 

[Gunjani]

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

Doesn't work!
--
Many Thanks

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

 

[Gunjani]

Typo Frank:

=WEEKDAY(B1,2)=6

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."

 

[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

 

[Frank Kabel]

Hi
see the corrections

 

[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

Thank U

--
Many Thanks

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

 

[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