Business Research Technology Microsoft Excel Tutorial – How to know the previous working date, when a date falls on weekend or holiday? January 25, 2023January 25, 2023 Usman Zafar Paracha 0 Comments business, education, Excel, microsoft, tutorialThis post contains formulae to know the previous working date, when a date falls on weekend or holiday. Check more here on SayPeople.com Formula to know the previous working date, when a date falls on weekend or holiday Rectangle.796 Formula to know the previous working date, when a date falls … Formula to know the previous working date, when a date falls on weekend or holiday 2-D word balloon Assuming that the date is mentioned in A2 Assuming that the date is mentioned in A2 Rectangle.798 =WORKDAY(A2+1,-1) =WORKDAY(A2+1,-1) Dynamic connector.799 Dynamic connector.802 gives gives Sheet.79 2-D word balloon.804 On this date, there is Sunday On this date, there is Sunday Sheet.81 Dynamic connector.805 Dynamic connector.801 example example Dynamic connector.806 gives gives 2-D word balloon.807 On this date, there is Monday On this date, there is Monday Rectangle.808 =WORKDAY(A2+1,-1,$E$2:$E$3) =WORKDAY(A2+1,-1,$E$2:$E$3) Dynamic connector.810 for holidays for holidays Sheet.83 Dynamic connector.811 example example Sheet.84 Dynamic connector.812 assuming holidays are mentioned in E2 and E3 assuming holidays are mentioned in E2 and E3 Dynamic connector.813 gives gives 2-D word balloon.814 Assuming that the date is mentioned in A2 and assumptions for… Assuming that the date is mentioned in A2 and assumptions for holidays are in E2 and E3 Sheet.86 Sheet.87 Sheet.88 Related
