This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I am trying to find a formula that will automatically add the add depending on one manual date entry for ONLY WEEKDAYS (Monday-Friday).
In excel you would use =(H7-10) which H7 would be your only manual date entry and the formulas from the next columns would add automatically the next dates. Again in excel this doesn’t do weekdays.
You would make a formula field and enter this formula: WORKDAY({name of your date field},-10). Assuming based on your example formula that you want to count 10 weekdays ago; if you want 10 weekdays in the future remove the negative sign.
