Hi.
I have done a google search and can't seem to find a formula for restricting the user input of a range to weekday dates only. Can this be done with Data Validation or do I need VBA code. Either solution would be greatly appreciated.
Hi.
I have done a google search and can't seem to find a formula for restricting the user input of a range to weekday dates only. Can this be done with Data Validation or do I need VBA code. Either solution would be greatly appreciated.
Casey
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
aristotle,
Despite my ramblings, you hit the nail on the head. Your solution worked perfectly. Here is my formula for the range of cells I wanted to protect.
=WEEKDAY(D20:D119,2)<6
Many Thanks.
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
Hi,
I'm not sure if I understand your question properly. Do you mean users will
input dates and you want to make sure that the dates correspond to working
days between Monday - Friday?
If so then you can set-up a validation as follows: Go to
Data->Validation->Settings
formula = WEEKDAY(B17,2)<6
Make sure your analysis toolpak is installed (Tools->Addins->Analysis
Toolpak->Ok)
Regards,
A
"Casey" wrote:
>
> Hi.
> I have done a google search and can't seem to find a formula for
> restricting the user input of a range to weekday dates only. Can this
> be done with Data Validation or do I need VBA code. Either solution
> would be greatly appreciated.
>
>
> --
> Casey
>
>
> ------------------------------------------------------------------------
> Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
> View this thread: http://www.excelforum.com/showthread...hreadid=394968
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks