DAYSTO

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

 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")

microsoft excel docs
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext