I'm working on a client report that needs statistics on number of days in inventory, number of days in Accts Pay, Number of days Accts Rec. etc.

To do the calculations each reporting period I need to calculate the number of days from the start of the fiscal year to the end of the reporting period.

For example a year end of Sep 30. Reporting period for the period Oct to Dec 2007 would calculate Oct 1 to Dec 31 = 91 days.

For End of the Current Fiscal Period
Use = ADGETF("gldates.END",FPRIOR(0)) (In Cell C6)

For Start of the Fiscal Year
Use =GLFPS("[1]M") (In Cell D6)

Then = C6-D6 will give you the number of days

or, you can just enter:

into the cell.