영업일 기준으로 날짜를 계산하는 방법

질문:

영업일 기준으로 날짜를 계산하려면
어떻게 할 수 있을까요?

주말에 공휴일까지요!

getDay() === 0 || 6 때로 주말은 계산되고,
공휴일은 제공하는 api로 받아와야겠지요?

공휴일은 매년 변경되니 정확한 정보를 위해서는 API로 땡겨와야겠죠?

 

To calculate the date in business days
How can you do that?

With weekends and public holidays!

getDay() === 0 || 6 Sometimes weekends are calculated,
holidays are calculated by the API you provide, right?

Holidays change every year, so we need to fetch them from the API for accurate information, right?

 

답:

To calculate a date in business days, accounting for weekends and public holidays, here’s a general approach:

1. Exclude Weekends (Saturday and Sunday)

Yes, using getDay() to check if a day is Saturday (6) or Sunday (0) is a common way to identify weekends in JavaScript:

 

주말과 공휴일을 고려하여 영업일 기준으로 날짜를 계산하려면 다음과 같이 일반적인 방법을 따르세요:

1. 주말(토요일 및 일요일) 제외
예, getDay()를 사용하여 요일이 토요일(6)인지 일요일(0)인지 확인하는 것은 JavaScript에서 주말을 식별하는 일반적인 방법입니다:

const isWeekend = (date) => date.getDay() === 0 || date.getDay() === 6;

 

2. Handle Public Holidays

Since public holidays vary by year and region, fetching them from an API is the best approach. Some common APIs to fetch holiday data are:

• Holiday API
• Calendarific API
• Government or region-specific APIs (e.g., US Federal Holidays)

3. Algorithm to Calculate Business Days

Here’s how you can calculate the target date by adding a specific number of business days:

1. Start with the given date.
2. Add one day at a time.
3. Skip weekends and public holidays.
4. Continue until the required number of business days is added.

2. 공휴일 처리
공휴일은 연도와 지역에 따라 다르므로 API에서 공휴일을 가져오는 것이 가장 좋은 방법입니다. 공휴일 데이터를 가져오는 몇 가지 일반적인 API는 다음과 같습니다:

휴일 API

https://holidayapi.com/
달력 관련 API

https://calendarific.com/
정부 또는 지역별 API(예: 미국 연방 공휴일)

Global Holiday Calendar API for National and Religious Holidays

 

Holidays are hard. Holiday API makes them easy.

 

 

3. 영업일 계산 알고리즘
특정 영업일 수를 추가하여 목표 날짜를 계산하는 방법은 다음과 같습니다:

주어진 날짜로 시작합니다.
한 번에 하루씩 추가합니다.
주말과 공휴일은 건너뜁니다.
필요한 영업일 수가 추가될 때까지 계속합니다.

 

Example Implementation in JavaScript

Here’s a full implementation:

자바스크립트로 구현한 예시
전체 구현은 다음과 같습니다:

 

async function calculateBusinessDate(startDate, businessDaysToAdd, fetchHolidays) {
    let currentDate = new Date(startDate);
    let addedDays = 0;
    
    // Fetch holidays as an array of strings (e.g., ['2024-01-01', '2024-12-25'])
    const holidays = await fetchHolidays();

    const isHoliday = (date) => {
        const formattedDate = date.toISOString().split('T')[0]; // Format: YYYY-MM-DD
        return holidays.includes(formattedDate);
    };

    while (addedDays < businessDaysToAdd) {
        currentDate.setDate(currentDate.getDate() + 1); // Increment by one day

        if (!isWeekend(currentDate) && !isHoliday(currentDate)) {
            addedDays++; // Count only business days
        }
    }

    return currentDate; // Final date after adding business days
}

// Helper function to check if a date is a weekend
const isWeekend = (date) => date.getDay() === 0 || date.getDay() === 6;

// Example usage with a mock holiday API
async function fetchHolidaysMock() {
    // Replace this with an actual API call
    return ['2024-01-01', '2024-12-25']; // Example holidays
}

(async () => {
    const startDate = new Date('2024-11-25');
    const businessDaysToAdd = 10;

    const targetDate = await calculateBusinessDate(startDate, businessDaysToAdd, fetchHolidaysMock);
    console.log(`Target Date: ${targetDate.toDateString()}`);
})();

 

 

 

Key Points:

1. Dynamic Holiday Fetching: Use an API like HolidayAPI to fetch public holidays for a specific region and year dynamically.
2. Edge Cases: Consider time zones and how holidays are formatted in the API response.
3. Performance: If you’re doing this calculation repeatedly, cache the holidays data locally to reduce API calls.

This approach ensures accurate handling of weekends and dynamically fetched public holidays.

 

요점
동적 공휴일 가져오기: HolidayAPI와 같은 API를 사용하여 특정 지역 및 연도의 공휴일을 동적으로 가져올 수 있습니다.
엣지 사례: 시간대와 API 응답에서 공휴일 형식이 어떻게 지정되는지 고려하세요.
성능: 이 계산을 반복적으로 수행하는 경우 공휴일 데이터를 로컬에 캐시하여 API 호출을 줄이세요.
이 접근 방식은 주말과 동적으로 가져온 공휴일을 정확하게 처리할 수 있습니다.