Excel: Calculating Days Remaining in a Time Period

 Last reviewed: November 30, 1994
Article ID: Q81026
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0
  • Microsoft Excel for the Macintosh, versions 2.x, 3.0, 4.0, 5.0

In Microsoft Excel, to find the number of days remaining in a time period (even division of a year) containing a specific date, use the following formula: 

   =DATE(YEAR(date),-INT(-(MONTH(date))/period)*period+1,1)-1-date
Replace "date" with the actual date, and replace "period" with the number of months in a period (for example, to calculate on a quarterly basis, use 3 as the period). This formula works for even divisions of a year and does not allow for variations in starting and ending dates of periods.

For example, using 8/4/92 as the date and 3 as the period would yield the value 57, meaning that there are 57 days remaining from 8/4/92 till the end of the quarter (3-month period) that contains the date.

NOTE: The value used for period should be an even divisor of 12 (that is, 2, 3, 4 or 6).

REFERENCES

"Microsoft Excel Function Reference," for the Macintosh, version 3.0, page 44

KBCategory: kbusage
KBSubcategory:

Additional reference words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.2 2.20
3.0 3.00 4.0 4.00 noupd 5.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.