In this article, we build a model using the seldom-seen Data Table to visualize at what point an Adwords campaign becomes profitable.Read more
A summary of how to use Function keys on a Mac with Excel and other applications, including information on system defaults and how to change these defaults.Read more
YEARFRAC returns a decimal number representing years between two dates. For example:
=YEARFRAC("1-Jan-2019","1-Jan-2020") // returns 1
=YEARFRAC("1-Jan-2019","1-Jul-2020") // returns 1.5
=YEARFRAC("1-Jan-2019","1-Jan-2021") // returns 2
...Read more
The DAYS360 function returns the number of days between two dates, based on a year where all months have 30 days. Both dates must be valid Excel dates or text values that can be parsed as dates. The DAYS360 function only works with whole numbers, time values ...Read more
The NETWORKDAYS function returns the number of working days between two dates, automatically excluding weekends (Saturday and Sunday) and optionally excluding holidays provided as a list of dates. NETWORKDAYS can be used to calculate employee benefits that accrue...Read more