Find weekdays

[bigbaded]

I am forcasting dates but need to ensure that date forcasted is a weekday (i.e. not Sat or Sun)

Ideas?

 

[stickboy]

you could have a long list of dates - mon to fri only in sequence, and then lookup your forcast against the list - use an if statement to clear it if it isnt found in the list.

 

[royUK]

Hi

=IF(WEEKDAY(A1)<6,A1," ")

If you place this formula in a column next to your date(in this example the date is in A1)it will return a blank for all weekends. You can then delete the rows containing blanks. The easiest way is to use the asap utility from http://www.asap-utilities.com. Use the Conditional Row or Column Select

 

[quigley]

The formula from RoyUK will only leave the field of Saturdays blank therfore the formula you require is
=IF(AND(WEEKDAY(A1)>1,(WEEKDAY(A1)<7)),A1," ")

 

[Aladin Akyurek]

On 2002-09-20 03:36, bigbaded wrote:
I am forcasting dates but need to ensure that date forcasted is a weekday (i.e. not Sat or Sun)

Ideas?

How do you do your forecasting -- using a formula?

 

[Mark W.]

=WEEKDAY(A1,2)<6

 

[Mark W.]

On 2002-09-20 04:57, royUK wrote:

=IF(WEEKDAY(A1)<6,A1," ")

royUK, your WEEKDAY function needs a return_type of 2 for this to work.