이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
DAYS(end_date, start_date)The DAYS function calculates the difference between two date values by subtracting the start_date from the end_date. It is useful for determining the duration of a project or the time elapsed between two specific calendar events.
=DAYS("2023-12-31", "2023-01-01")결과: 364
Calculates the number of days between January 1st and December 31st, 2023.
Yes, if the start_date is later than the end_date, the function will return a negative number.