Business Apps - Custom Functions in Excel

DAYSTO

DAYSTO(event_name [,unit] [,display_unit])
Returns the number of days (or units) to a particular event/date.

event_name

The actual cells to average.

unit

(Optional) The unit to use:
Days
Months
Years

display_unit

(Optional) Whether to display the unit after the number.

REMARKS
* If "unit" is left blank, then Days is used.
* If "display_unit" is left blank, then True is used.
* This page has the equivalent VBA function.

	A
1	=JS.DAYSTO("Christmas") = 1 days
2	=JS.DAYSTO("Christmas", "days") = 1 days
3	=JS.DAYSTO("Christmas", "months") = 0.0328767 months
4	=JS.DAYSTO("Christmas", "years") = 'years' is an invalid unit
5	=JS.DAYSTO("CHRISTMAS") = 1 days
6	=JS.DAYSTO("Easter") = 0
7	=JS.DAYSTO("Mothers Day") = 0
8	=JS.DAYSTO("Fathers Day") = 0