Date & Time Formulas

Add business days to a dateDate - Add or Subtract
Add business days to a date changing the days of the weekendDate - Add or Subtract
Add business days to a date excluding public holidaysDate - Add or Subtract
Add days to a date excluding weekendsDate - Add or Subtract
Add days to a date excluding weekends and changing the days of the weekendDate - Add or Subtract
Add days to a date excluding weekends and public holidaysDate - Add or Subtract
Add days to a date including weekendsDate - Add or Subtract
Add days to a date not landing on a weekendDate - Add or Subtract
Add hours to a timeTime - Add or Subtract
Add minutes to a timeTime - Add or Subtract
Add months to a dateDate - Add or Subtract
Add seconds to a timeTime - Add or Subtract
Add weeks to a dateDate - Add or Subtract
Add working days to a dateDate - Add or Subtract
Add working days to a date changing the days of the weekendDate - Add or Subtract
Add working days to a date excluding public holidaysDate - Add or Subtract
Add years to a dateDate - Add or Subtract
Convert a date string to a date valueDate - Convert
Convert hours to a timeTime - Convert
Convert minutes to a timeTime - Convert
Convert seconds to a timeTime - Convert
Convert time to time zoneTime - Convert
Number of business daysDate - Number of Days
Number of business days between 2 datesDate - Number of Days
Number of business days in a particular monthDate - Number of Days
Number of business days in a particular yearDate - Number of Days
Number of business days left in the current monthDate - Number of Days
Number of business days left in the current yearDate - Number of Days
Number of business days that have passed in the current monthDate - Number of Days
Number of business days that have passed in the current yearDate - Number of Days
Number of days between 2 datesDate - Number of Days
Number of days between 2 dates excluding weekendsDate - Number of Days
Number of days in a particular monthDate - Number of Days
Number of days in a particular yearDate - Number of Days
Number of days left in the current monthDate - Number of Days
Number of days left in the current yearDate - Number of Days
Number of days that have passed in the current monthDate - Number of Days
Number of days that have passed in the current yearDate - Number of Days
Number of mondays between 2 datesDate - Number of Days
Number of months between 2 datesDate - Number of Months
Number of occurrences of a particular day of the weekDate - Number of
Number of weekend daysDate - Number of
Number of weekend days between 2 datesDate - Number of
Number of weekend days in a particular monthDate - Number of
Number of weekend days in a particular yearDate - Number of
Number of weeks between 2 datesDate - Number of
Number of working daysDate - Number of
Number of working days between 2 datesDate - Number of
Number of working days in a particular monthDate - Number of
Number of working days in a particular yearDate - Number of
Number of working days left in the current monthDate - Number of
Number of working days left in the current yearDate - Number of
Number of working days that have passed in the current monthDate - Number of
Number of working days that have passed in the current yearDate - Number of
Number of working hours between 2 datesTime - Number of
Number of working hours between 2 timesTime - Number of
Number of years between 2 datesDate - Number of Years
Return a date in a particular formatDate - Display
Return a date in US date formatDate - Display
Return a persons age in yearsDate - Display
Return the 3rd monday in a monthDate - Display
Return the business daysDate - Display
Return the current dateDate - Display
Return the current date and timeDate - Display
Return the current dayDate - Display
Return the current monthDate - Display
Return the current quarterDate - Display
Return the current timeTime - Display
Return the current yearDate - Display
Return the date from a date and timeDate - Display
Return the date of the monday in the current weekDate - Display
Return the date of the monday in the next weekDate - Display
Return the date of the monday in the previous weekDate - Display
Return the day from dateDate - Return
Return the day nameDate - Display
Return the first business day of the yearDate - First
Return the first day of the current monthDate - First
Return the first day of the next monthDate - First
Return the first day of the previous monthDate - First
Return the first monday of the current monthDate - First
Return the first monday of the next monthDate - First
Return the first monday of the previous monthDate - First
Return the first weekday of the yearDate - First
Return the last business day of the yearDate - Last
Return the last day of the current monthDate - Last
Return the last day of the next monthDate - Last
Return the last day of the previous monthDate - Last
Return the last monday of the current monthDate - Last
Return the last monday of the next monthDate - Last
Return the last monday of the previous monthDate - Last
Return the last weekday of the yearDate - Last
Return the month from a dateDate - Return
Return the next business dayDate - Display
Return the next working dayDate - Display
Return the nth business day of the yearDate - Return
Return the nth day of the yearDate - Return
Return the number corresponding to a given monthDate - Display
Return the time elapsed between 2 timesTime - Display
Return the time from a date and timeTime - Display
Return the time rounded to the nearest 15 minutesTime - Display
Return the week number of the current dateDate - Display
Return the working hours between 2 datesTime - Display
Return the working hours between 2 timesTime - Display
Return the year from a dateDate - Return
Subtract days from a dateDate - Add or Subtract
Subtract hours from a timeDate - Add or Subtract
Subtract minutes from a timeDate - Add or Subtract
Subtract months from a dateDate - Add or Subtract
Subtract seconds from a timeDate - Add or Subtract
Subtract weeks from a dateDate - Add or Subtract
Subtract years from a dateDate - Add or Subtract
Test if a year is a leap yearDate - Test

© 2018 Better Solutions Limited. All Rights Reserved. © 2018 Better Solutions Limited