Business Apps - Custom Functions in Excel

DAYSTO

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.
* The equivalent VBA function is DAYSTO

	A
1	=_xldudf_JS_ID4_DAYSTO("Christmas") = #NAME?
2	=_xldudf_JS_ID4_DAYSTO("Christmas", "days") = #NAME?
3	=_xldudf_JS_ID4_DAYSTO("Christmas", "months") = #NAME?
4	=_xldudf_JS_ID4_DAYSTO("Christmas", "years") = #NAME?
5	=_xldudf_JS_ID4_DAYSTO("CHRISTMAS") = #NAME?
6	=_xldudf_JS_ID4_DAYSTO("Easter") = #NAME?
7	=_xldudf_JS_ID4_DAYSTO("Mothers Day") = #NAME?
8	=_xldudf_JS_ID4_DAYSTO("Fathers Day") = #NAME?