June 30th, June 26th to 30th is five days.

July 3 1 day and August 3 1 day, these two months have 62 days.

Plus one day in September, * * has 5+62+ 1=68 days.

Example:

Topic: Calculate the age of the person whose birth date is 1973-4- 1

Formula: = datedif ("1973-4-1",today (), "y")

Result: 33

Description: When the company code is "Y", the calculation result is the number of years between two dates.

If it is the same month, subtract it directly.

For example, the period from September 9th to September 10 is 10-9= 1 day!

If it is a different month, you should consider how much it is on the last day of this month!

For example, from September 9th to 10, 10!

That's because the end of September is 30 days!

So the interval is 30-9+ 10=3 1 day!

If it is from July 9 to August 9, this algorithm is different! Because the end of July is 3 1 day!