Hello,
I am using excel to track the deadline for applications. The applicant has 8 working days (the first being the date of application) to the deadline. The problem being my formula only starts counting from the next working day, for example:
=WORKDAY(A301,8,Workday!A$4:A$14)
A301 = 15/3/12 which the formula gives as 27/3/12 for the deadine when it should read 26/3/12.
(A4:A14 are the holidays on a separate page)
The formula works fine for applications received on a weekend as they are not received on a working day and so that day does not need to be counted? I basically need the formula to count 7 days from the start date if the application is received on a weekday and 8 if received on a weekend.
Could anyone help please?
Thanks in advance
Bookmarks