I have some problem in calculate total working days and excepted leave days in one month, my formula just points out number of start day of the leave.
All details, I wrote in the attached file.
I have some problem in calculate total working days and excepted leave days in one month, my formula just points out number of start day of the leave.
All details, I wrote in the attached file.
Last edited by megaiooo; 07-21-2013 at 08:54 AM.
What is your designed input in Print sheet?
Ví dụ : Cổ Thiên Lạc leave from 28-Oct to 4-Nov, how the time sheet appear?
Quang PT
I don't know Vietnamese language what you said =)), that's awesome!
Sorry, I'm just kidding
The way I want the time sheet shows that:
when I select October, the dates which Cổ Thiên Lạc leaved from 28-Oct to 31-Oct don't appear in the time sheet
and when I select November, the dates from 01-Nov to 04-Nov that disappear too
Last edited by megaiooo; 07-21-2013 at 03:36 AM.
Duplicate post, sorry
Last edited by bebo021999; 07-21-2013 at 04:43 AM.
You mean sth like this in C7?
D7:Please Login or Register to view this content.
Please Login or Register to view this content.
It could be that I give you lack information, sorry! Actually, I mean that:
In the range C7:C37 always shows start time of every working day starting at 7:30 am. The formula in range C7:C37 works depending on appearance of days in a month, for instance:
- in January, days appear start from 01 to 31;
- in February, days appear from 01 to 28;
- so on...)
Because it depends on appearance of days of each month, the result would show in the range C7:C37 as below:
- In January, 7:30 am appears in the same row of day 01, and its the last appearance in the same row of day 31;
- In February, 7:30 am appears in the same row of day 01, and its the last appearance in the same row of day 28;
- etc.
But, in the case that an employee has day off, I want 7:30 am to stop appearing on the day he/she leaving, for instance:
Mr. Lac gets sick on the day 20 in January, therefore, he must stay at home => 7:30 am of the day 20 would disappear
(or another way: in January, regarding Mr. Lac's day off, 7:30 am will appear from day 01 to day 19, and disappear on day 20, then appear again from day 21 to day 31)
This is a very difficult issue for me to create a formula available to treat issue well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks