Monday, June 20, 2011

yogi_Count Number Of Days Between Two Dates

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

oldPhil said:
The date function days360 returns 1 day between may 30 & June 1
----------------------------------------------------------------------
DAYS360 function is based on there being 30 days in each of the 12 months in a year ... so it should not be used to count the number of days between two dates.

No comments:

Post a Comment