DAYSTO

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

event_nameThe 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.
Enumeration - Easter, Christmas, Valentines

 A
1=JS.DAYSTO("Christmas")
2=JS.DAYSTO("Christmas","days")
3=JS.DAYSTO("Christmas","months")
4=JS.DAYSTO("Christmas","years")
5=JS.DAYSTO("CHRISTMAS")
6=JS.DAYSTO("Easter")
7=JS.DAYSTO("Mothers Day")
8=JS.DAYSTO("Fathers Day")


© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext