DIAS LAB.

| domingo, 22 de febrero de 2009

This function returns a working day is calculated from a date which is obtained by adding a certain number of days taken to this date. For example if we start from the days 1/1/2004 and we add 8 days to get working as a business day closest to this date the January 13 because they are not counted either Saturday or Sunday. In this role as in DIAS.LAB will add a list of holidays that will not be counted as working days. Structure: DIA.LAB (Date initial, Weekdays, Holidays), where days is the number of days counting from the start date and Holidays will be the range of holidays that we are not regarded as working. Example: In cell A1 enter the starting date, eg 01/01/2004 and in cell A2 put the number of days that we wish to add that appears in cell A1, in this case we will try to add an 8 to 8 days from January 1. In cell B4 type this DIA.LAB = (A1, A2) and obtain results in the 13/01/2004, we see that only business days are counted. If you wish to add dates that are not working we have to make a small change in this function. In cells A7 and A8 introduce on 01/01/2004 and 06/01/2004. In the role of cell B4 should add a third argument is the formula as follows DIA.LAB = (A1, A2, A7: A8), now the resulting date is the day January 14.
MORE INFORMATION ON THE TOPIC.
http://www.aulaclic.es/access2007/b_2_1_1.htm

0 comentarios:

Publicar un comentario