The WORKDAY function in Excel takes three parameters, a start date, a number of days and an optional parameter, which is the number of bank holidays within the period. The function returns the date that is the given number of days after the start date. If you enter a negative number for the days parameter, the function returns the date that is the given number of days before the start date. If there are weekend dates in the period, the function does not count those days, so if you enter a date that is a Monday and specify -3 for the days offset, the function will return the previous Wednesday not Friday. You can enter the address of a cell for any of the parameters.
- Skill level:
Other People Are Reading
Enter =WORKDAY(’11-May-2013’,5) into a cell in an Excel spreadsheet. Press the “Enter” key. This will return an error because the first parameter requires a date type and ’11-May-2013’ has a character type.
Enter =WORKDAY(DATE(2013,5,11),5) into cell A2. This will work and show the number 41411. This is the number of days since 1st January, 1900, which is not very useful. Right click on the cell and select “Format Cells” from the right-click menu. Click on ‘date” in the Category list and select “English (UK) for the locale. Select your preferred date format in the “Type” list. Press the “OK” button. The cell will now show the 17th May 2013 in the format you specified.
Go to cell A1 and click the right mouse button. Select “Format Cells” from the right-click menu. In the “Format Cells” window, select “Date” from the “Category” list and select “English (UK) from the “Locale” pick list. Select a date format from the “Type” list and then click on the “OK” button. Enter ’09-May-13’ in cell A1. When you press “Enter” this will be converted to the date format you specified in the “Format Cells” window.
Click in cell A2 where you entered the WORKDAY function. Click in the formula bar at the top of the spreadsheet. Replace “DATE(2013,5,11)” with “A1”. Press the “Enter” key. The cell will now show the date 16th May 2013 in the format you chose.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for