Holidays option in Workday function - Microsoft Community
in workday function, holidays option work year?
i.e. if set jan/1st of last year, consider if range of dates fall in following years?).
in other words if set january 1st, 2016 holiday , want know 600 days today (9/1/2017), skip 1/1/2018 , 1/1/2019?
hi,
no, consider th holidays thate equal or greater start date.
i did not test seems there work-around, see snip:
| holidays | 01/02/ | ||||||
| 01/03/ | 01/01/2017 | 1 | |||||
| 01/04/2017 | 01/02/2017 | 2 | |||||
| 01/18/2017 | 01/03/2017 | 3 | |||||
| 01/04/2017 | 4 | ||||||
| start date | 01/01/2017 | 01/05/2017 | 5 | ||||
| nr of days | 01/10/1900 | 01/06/2017 | 6 | ||||
| 01/07/2017 | 7 | ||||||
| 01/08/2017 | 1 | ||||||
| 01/09/2017 | 2 | ||||||
| 01/10/2017 | 3 | ||||||
| 01/11/2017 | 4 | ||||||
| 01/12/2017 | 5 | ||||||
| 01/13/2017 | 6 | ||||||
| 01/14/2017 | 7 | ||||||
| 01/15/2017 | 1 | ||||||
| 01/16/2017 | 2 | ||||||
| 01/17/2017 | 3 | ||||||
| 01/18/2017 | 4 | ||||||
| 01/19/2017 | 5 |
formula: =workday(f6,f7,if(isnumber(f1:f3),f1:f3,f1:f3&year(today())))
this array formula, enter ctrl+shift+enter
Office / Excel / Windows 8 / Office 365 for business
Comments
Post a Comment