Weekday() / Workday() - maybe?

  • Thread starter Thread starter BIG-DB
  • Start date Start date
B

BIG-DB

I Have a sheet like this.

B C D E F G
1 =c1-1 =d1-1 =e1-1 =f1-1 =g1-1 Tue
2 =c1-2 =d1-2 =e1-2 =f1-2 =g1-2 18/5/04
3

The data in rows 3-10 are linked or calculations from
other sheets etc:
I update 'G2' daily and columns B-F all update or refresh
nicely.
My problem is I do not have Sat or Sun data and with the
example above col D & E end up with Sat and Sun and zeros
in cells 3-10.

Is there some formula or condition I can use to not have
Sat and Sun show up but in this case have Tues, Wed, Thur,
Fri, Mon & the Tuesday I enter in G2.

I thought workdays () might be the answer but I do not
understand what it is telling me.

Any help would be greatly appreciated. I hope this is
understandable.
David
 
Hi
WORKDAYS will add a number of workdays to a given date (excluding
Sat./Sun. and holidays if specified). e.g.
WORKDAY(DATE(2004,16,5),2)
will add two workdays to 5/16/2004
 
thanks frank. I think I understand now.
-----Original Message-----
Hi
WORKDAYS will add a number of workdays to a given date (excluding
Sat./Sun. and holidays if specified). e.g.
WORKDAY(DATE(2004,16,5),2)
will add two workdays to 5/16/2004

--
Regards
Frank Kabel
Frankfurt, Germany




.
Click to expand...
 
Back
Top