Skip to main content

WEEKDAY FORMULA

  • September 3, 2019
  • 1 reply
  • 136 views
B

Hi,

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.

Anyone have any tricks?

    1 reply

    Kamille_Parks11
    Forum|alt.badge.img+27

    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.

      Terms & ConditionsAccessibility statement