User Profile
Koi16
Copper Contributor
Joined Feb 01, 2023
User Widgets
Recent Discussions
DATEDIF FUNCTION
Hi, I'm wondering how does the DATEDIF FUNCTION calculates when using "Y" unit and "M" unit. Sometimes this function may result in a wrong number. For example, I used this function to calculate month between 2000/01/31 and 2000/02/29 and the result was 0. But in fact the result should be 1 month, because the start date is the end of January and the end date is the end of February. I want to figure out why this error happened.
