Use WORKDAY style function using a 6 day week

[kev8279]

Hi,

I am tring to find work out dates going backwards using the WORKDAY function excluding holidays. This works fine apart from it omits Saturdays and I want to include them. The only things I need to omit are Sundays and public holidays. Can anyone help?

I have a cell (E1) with my first date of =TODAY()-1 which is where my dates start.

 

[barry houdini]

Which version of Excel are you using? If you have Excel 2010 you can use WORKDAY.INTL function and customise that to include Saturdays

otherwise try this formula to get the previous workday to E1, assumes that holidays are listed in H1:H10

=E1-MIN(IF(WEEKDAY(E1-{1,2,3,4,5})<>1,IF(ISNA(MATCH(E1-{1,2,3,4,5},$H$1:$H$10,0)),{1,2,3,4,5})))

 

[kev8279]

Thanks!! This works perfectly!