| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for adding days to a date excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
| Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
| excluding my country's weekends | Excel Worksheet Functions | |||
| Calculate number of hours between dates and times excluding Weekends | Excel Discussion (Misc queries) | |||
| Formula - Excluding weekends & holidays | Excel Worksheet Functions | |||
![Urgent question regarding LIST[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
