Manuals/calci/WORKDAY
Jump to navigation
Jump to search
Syntax
Examples
''''''' ''''
Description
This function gives a number that represents a date that is the indicated number of working days before or after a date..
WORKDAY
Let's see an example in Column1Row1,Column2Row1 and Column3Row1:Column3Row3
C1R1=06/01/2008
C2R1 = 140
C3R1 = 10/02/2008(hdays)
C3R2 =10/30/2008(hday)
C3R3 = 08/15/2008(hdays)
I.e. =WORKDAYS(C1R1,C2R1) is Sun Dec 14 00:00:00 UTC+0530 2008
///rly =WORKDAYS(C1R1,C2R1,C3R1:C3R3) is Tue Dec 16 00:00:00 UTC+0530 2008
WORKDAY(SD,dys,HD)
where SD is a date that represents the start date and dys is the number of nonweekend and nonholiday days before or after start date and HD is an optional list of one or more dates to exclude from the working calendar.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 06/01/2008 | 140 | 10/02/2008(hdays) | Sun Dec 14 00:00:00 UTC+0530 2008 |
| Row2 | 10/30/2008(hday) | Tue Dec 16 00:00:00 UTC+0530 2008 | ||
| Row3 | 08/15/2008(hdays) | |||
| Row4 | ||||
| Row5 | ||||
| Row6 |
