Date & Time

EDATEThe date serial number that is a certain number of months before or after a date.
EOMONTHThe serial number of the last day of a month before or after a date.
NETWORKDAYS(NETWORKDAYS.INTL) The total number of working days between two dates excluding weekends and holidays.
WEEKNUMThe week number in the year for a given date.
WORKDAY(WORKDAY.INTL) The serial number that is a given number of working days before or after a date.
YEARFRACThe number of years as a decimal between two dates.

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top