One way:

=WEEKDAY(J6,3)4

or

=IF(WEEKDAY(J6,3)4,<do if true,<do if false)

In article ,
Supriya wrote:

If the entered date is either Saturday or sunday, then calculation
should take place.


=IF(OR(WEEKDAY(J6)=1,7),"True","False")

Is the above formula is correct?


---
Message posted from http://www.ExcelForum.com/