workweek
So did you want to fill Column A with only Weekdays or did you want to
identify the dates in column A as being either Weekday or Weekend?
If you want to fill in only weekdays in Column A then the easiet is to place
a date in column A. Instead of dragging the date with the left mouse button
depressed, depress the right mouse button. When you are done dragging you
will get a menu which will allow you to fill only the weekdays.
If you need the formula
=IF(OR(WEEKDAY(A1)=1, WEEKDAY(A1)=7), "WeekEnd", "WeekDay")
--
HTH...
Jim Thomlinson
"Richard" wrote:
Column A contains dates. But I only need weekday dates when filled in. Can
someone help with the formula to do so. Thanks in advance
|