Am trying to work out the end date when I know the start date and duration, based on excluding weekends. In a previous pivot table the below formula works perfectly
=WORKDAY.INTL([@[Start Date]]-1,[@Duration],1)
My issue is trying to insert the forumla before I create my pivot table, so I have been using:
=WORKDAY.INTL(I2:I59)-1,(J2:J59),1)
I am getting an error that there are too few arguments for the function - what am I missing???
thxs
Hi Andrea,
Here is the function : WORKDAY.INTL function
WORKDAY.INTL(start_date, days, [weekend], [holidays])
The WORKDAY.INTL function syntax has the following arguments:
- Start_date : Required. The start date, truncated to integer.
- Days : Required. The number of workdays before or after the start_date. A positive value yields a future date; a negative value yields a past date; a zero value yields the start_date. Day-offset is truncated to an integer.
- Weekend : Optional. Indicates the days of the week that are weekend days and are not considered working days. Weekend is a weekend number or string that specifies when weekends occur.
Try this :
=WORKDAY.INTL(I2-1,J2,1)
Hi Lionel
thanks for the response and the syntax, unfortunately it only works on the first line and I have another 58 rows which need to be included, I don't believe that I need to add in manually on each line and should be able to cover all rows, so i changed the syntax to include all rows
=WORKDAY.INTL(I2:I59-1,J2:J59,1)
and got an error again, any ideas??
cheers
Andrea,
When you are not using a structured table, you must use a line-by-line formula. The easiest way is to start from the first line (which works) and extend it to the rest of the lines; either with a copy and paste or by using the copy handle.
BR?
Lionel
It is in a structured table - but I rang a local excel trainer and she was able to work through the issues and its all good now.
Thanks for your input
