working with dates in fiscal years
i am trying to calculate the percentage of the year that someone has been
employed with my company.
for example, they began on 2004-11-24, and i am trying to use formula tro
calculate the number of days they are employed from that date until
2005-03-31.
i have been using the DATE() function, but am getting less than satisfactory
results
i am wondering if there is a way to calculate the number of days between one
specified date and another.
thanks for all your help!
|