Formula to write Calendar dates excluding weekends - urgent pleas
 

Hello,
I need to create a time tracking sheet for 3 employees working on certain
tasks. I need to track their time they worked on these tasks for each day.
The employee should go in each day and write how many hours they worked each
day on those tasks..

I need to write a formula that can list all the calendar dates for year 2008
without weekends...or that can highlight the weekends......

This is due by monday..can someone please help me

Thanks and regards. appreciate all the help.

pooja

Formula to write Calendar dates excluding weekends - urgent pleas
 

The easiest way is to not use a formula. Type in your first date. Grab the
drag handle with the right click button and drag the date down. When you
release the right click button you will get a list of options, one of which
is Fill Weekdays... and you are done...
--
HTH...

Jim Thomlinson


"Urgent question regarding LIST" wrote:

Hello,
I need to create a time tracking sheet for 3 employees working on certain
tasks. I need to track their time they worked on these tasks for each day.
The employee should go in each day and write how many hours they worked each
day on those tasks..

I need to write a formula that can list all the calendar dates for year 2008
without weekends...or that can highlight the weekends......

This is due by monday..can someone please help me

Thanks and regards. appreciate all the help.

pooja

Formula to write Calendar dates excluding weekends - urgent p
 

Thanks Jim, it helped.....appreciate it
pooja

"Jim Thomlinson" wrote:

The easiest way is to not use a formula. Type in your first date. Grab the
drag handle with the right click button and drag the date down. When you
release the right click button you will get a list of options, one of which
is Fill Weekdays... and you are done...
--
HTH...

Jim Thomlinson


"Urgent question regarding LIST" wrote:

Hello,
I need to create a time tracking sheet for 3 employees working on certain
tasks. I need to track their time they worked on these tasks for each day.
The employee should go in each day and write how many hours they worked each
day on those tasks..

I need to write a formula that can list all the calendar dates for year 2008
without weekends...or that can highlight the weekends......

This is due by monday..can someone please help me

Thanks and regards. appreciate all the help.

pooja