Formula to Identify Working Day Number

[dmpope]

Hi there,

I'm trying to figure out what formula I need to do this but I'm struggling. I have a set of journal entries posted by Accounting and I need to identify what day of close those entries were posted on based on the date. So for example, I need:

JE Date      Close Day

9/3/24              1

9/4/24              2

9/5/24              3

9/6/24              4

9/9/24              5

9/10/24            6

9/11/24            7

9/12/24            8

I obviously need this to be dynamic when the JE Date changes and when there's holidays (like how 9/2/24 was a holiday). I initially had a text input so that the user would select the dates for each close day, but if there's a formula(s) that can be used, then I'd rather do that to make it more efficient. If anyone has any thoughts that would be great!

Thank you!

[Deano478 · Accepted solution]

@dmpope since countries different have different holidays for that part your better of getting a calendar or a list online of holidays pertaining to your region and joining that in to identify holiday dates. the attached will at least give you start