Hello ,
Is there any formula we can use to get result in Column E (WD Day )
Is there any formula we can use to get result in Column E (WD Day )
Posting Month | Entry Date | Posting Month_Entry Date | Week Day | WD Day | Workday Group | Period | Quarter Close/Non Qtr | US Public Holiday |
1/1/2023 | 1/1/2023 | 44927_44927 | Sunday | WD-21 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/2/2023 | 44927_44928 | Monday | WD-21 | Non Month Close | 1 | Non Quarter End | New Year’s: Monday, January 2 |
1/1/2023 | 1/3/2023 | 44927_44929 | Tuesday | WD-20 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/4/2023 | 44927_44930 | Wednesday | WD-19 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/5/2023 | 44927_44931 | Thursday | WD-18 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/6/2023 | 44927_44932 | Friday | WD-17 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/7/2023 | 44927_44933 | Saturday | WD-16 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/8/2023 | 44927_44934 | Sunday | WD-16 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/9/2023 | 44927_44935 | Monday | WD-16 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/10/2023 | 44927_44936 | Tuesday | WD-15 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/11/2023 | 44927_44937 | Wednesday | WD-14 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/12/2023 | 44927_44938 | Thursday | WD-13 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/13/2023 | 44927_44939 | Friday | WD-12 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/14/2023 | 44927_44940 | Saturday | WD-11 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/15/2023 | 44927_44941 | Sunday | WD-11 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/16/2023 | 44927_44942 | Monday | WD-11 | Non Month Close | 1 | Non Quarter End | Martin Luther King Jr.: Monday, January 16 |
1/1/2023 | 1/17/2023 | 44927_44943 | Tuesday | WD-11 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/18/2023 | 44927_44944 | Wednesday | WD-10 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/19/2023 | 44927_44945 | Thursday | WD-9 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/20/2023 | 44927_44946 | Friday | WD-8 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/21/2023 | 44927_44947 | Saturday | WD-7 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/22/2023 | 44927_44948 | Sunday | WD-7 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/23/2023 | 44927_44949 | Monday | WD-7 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/24/2023 | 44927_44950 | Tuesday | WD-6 | Non Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/25/2023 | 44927_44951 | Wednesday | WD-5 | Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/26/2023 | 44927_44952 | Thursday | WD-4 | Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/27/2023 | 44927_44953 | Friday | WD-3 | Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/28/2023 | 44927_44954 | Saturday | WD-2 | Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/29/2023 | 44927_44955 | Sunday | WD-2 | Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/30/2023 | 44927_44956 | Monday | WD-2 | Month Close | 1 | Non Quarter End | |
1/1/2023 | 1/31/2023 | 44927_44957 | Tuesday | WD-1 | Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/1/2023 | 44927_44958 | Wednesday | WD+1 | Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/2/2023 | 44927_44959 | Thursday | WD+2 | Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/3/2023 | 44927_44960 | Friday | WD+3 | Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/4/2023 | 44927_44961 | Saturday | WD+3 | Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/5/2023 | 44927_44962 | Sunday | WD+3 | Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/6/2023 | 44927_44963 | Monday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/7/2023 | 44927_44964 | Tuesday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/8/2023 | 44927_44965 | Wednesday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/9/2023 | 44927_44966 | Thursday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/10/2023 | 44927_44967 | Friday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/11/2023 | 44927_44968 | Saturday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/12/2023 | 44927_44969 | Sunday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/13/2023 | 44927_44970 | Monday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/14/2023 | 44927_44971 | Tuesday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/15/2023 | 44927_44972 | Wednesday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/16/2023 | 44927_44973 | Thursday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/17/2023 | 44927_44974 | Friday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/18/2023 | 44927_44975 | Saturday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/19/2023 | 44927_44976 | Sunday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/20/2023 | 44927_44977 | Monday | WD>+3 | Post Month Close | 1 | Non Quarter End | President’s Day: Monday, February 20 |
1/1/2023 | 2/21/2023 | 44927_44978 | Tuesday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/22/2023 | 44927_44979 | Wednesday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/23/2023 | 44927_44980 | Thursday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/24/2023 | 44927_44981 | Friday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/25/2023 | 44927_44982 | Saturday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/26/2023 | 44927_44983 | Sunday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/27/2023 | 44927_44984 | Monday | WD>+3 | Post Month Close | 1 | Non Quarter End | |
1/1/2023 | 2/28/2023 | 44927_44985 | Tuesday | WD>+3 | Post Month Close | 1 | Non Quarter End |