Calulating day of week

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

I have a spread sheet where I need to fill in days that I was at work, we
put an X in the field if we were here. This would mean no X for Saturday or
Sunday. What I want to do is have the ability to put the beginning pay
period date in a field, and have the spread sheet place the X for each day
that isn't Sat or Sun. I am very Excel challenged so I'm not even sure where
to begin on this. Any help would be appreciated.

--
Thanks
Wayne Sepega
Jacksonville, Fl


"When a man sits with a pretty girl for an hour, it seems like a minute. But
let him sit on a hot stove for a minute and it's longer than any hour.
That's relativity." - Albert Einstein
 
If the date is in A1, then in B1

=IF(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7),"","X")

and copy down.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Hi

When the start day is in A2, then into A3 enter the formula:
=WORKDAY(A2,1,Holydays)
(Holidays is or reference to state holidays list somewhere in workbook, or
those holidays are simply listed in formula) and copy it down. As result you
get a list of working days - no need to bother about weekends or state
holidays anymore.


Arvi Laanemets
 
Back
Top