-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
workweek
-
E
searching the startdate after an interruption
Employee workweek Employee Answer 5000 week 33 5000 week 32 6000 week 33...- economicsbusiness
- Thread
- employee interruption max if large if date week workweek
- Replies: 5
- Forum: Excel Questions
-
U
Networkdays.intl
I have a facility that operates 6-days a week Mon - Saturday. I need to be able to calculate the net workdays. In cell L2 is the month. For the normal workweek Mon-Friday I have the following formula "=NETWORKDAYS(L2,EOMONTH(L2,0))". Reading about the NETWORKDAYS.INTL I see you can designate the...- UFGATORS
- Thread
- formula mon-friday networkdays.intl reading workweek
- Replies: 7
- Forum: Excel Questions
-
U
Formula for calculating EOM when Saturday is a workday
Hello, I have a facility where their workweek is Monday through Saturday an I need to be able to determine which day of the month will be the last workday, EOM. I'm currently using this formal for a normal 5-day workweek "=IF(WORKDAY(EOMONTH($L$2,0)+1,-1,holidays)=AJ2,"EOM","")". I did some...- UFGATORS
- Thread
- day eom formula saturday workweek
- Replies: 2
- Forum: Excel Questions
-
D
formulaa for displaying work week
Hey guys, So i'm trying to make a table where the headers are based on the dates from another tables headers. for example, if table1 headers are 8/14 8/15, 8/17, i want the header in table 2 to say "week of 8/14 i have a pseudo code in mind, but not sure how to implement it find previous...- dshafique
- Thread
- cell macros monday vba workweek
- Replies: 0
- Forum: Excel Questions
