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
Add business days to a date
Date - Add or Subtract
Add business days to a date changing the days of the weekend
Date - Add or Subtract
Add business days to a date excluding public holidays
Date - Add or Subtract
Add days to a date excluding weekends
Date - Add or Subtract
Add days to a date excluding weekends and changing the days of the weekend
Date - Add or Subtract
Add days to a date excluding weekends and public holidays
Date - Add or Subtract
Add days to a date including weekends
Date - Add or Subtract
Add days to a date not landing on a weekend
Date - Add or Subtract
Add hours to a time
Time - Add or Subtract
Add minutes to a time
Time - Add or Subtract
Add months to a date
Date - Add or Subtract
Add seconds to a time
Time - Add or Subtract
Add weeks to a date
Date - Add or Subtract
Add working days to a date
Date - Add or Subtract
Add working days to a date changing the days of the weekend
Date - Add or Subtract
Add working days to a date excluding public holidays
Date - Add or Subtract
Add years to a date
Date - Add or Subtract
Convert a date string to a date value
Date - Convert
Convert hours to a time
Time - Convert
Convert minutes to a time
Time - Convert
Convert seconds to a time
Time - Convert
Convert time to time zone
Time - Convert
Number of business days
Date - Number of Days
Number of business days between 2 dates
Date - Number of Days
Number of business days in a particular month
Date - Number of Days
Number of business days in a particular year
Date - Number of Days
Number of business days left in the current month
Date - Number of Days
Number of business days left in the current year
Date - Number of Days
Number of business days that have passed in the current month
Date - Number of Days
Number of business days that have passed in the current year
Date - Number of Days
Number of days between 2 dates
Date - Number of Days
Number of days between 2 dates excluding weekends
Date - Number of Days
Number of days in a particular month
Date - Number of Days
Number of days in a particular year
Date - Number of Days
Number of days left in the current month
Date - Number of Days
Number of days left in the current year
Date - Number of Days
Number of days that have passed in the current month
Date - Number of Days
Number of days that have passed in the current year
Date - Number of Days
Number of mondays between 2 dates
Date - Number of Days
Number of months between 2 dates
Date - Number of Months
Number of occurrences of a particular day of the week
Date - Number of
Number of weekend days
Date - Number of
Number of weekend days between 2 dates
Date - Number of
Number of weekend days in a particular month
Date - Number of
Number of weekend days in a particular year
Date - Number of
Number of weeks between 2 dates
Date - Number of
Number of working days
Date - Number of
Number of working days between 2 dates
Date - Number of
Number of working days in a particular month
Date - Number of
Number of working days in a particular year
Date - Number of
Number of working days left in the current month
Date - Number of
Number of working days left in the current year
Date - Number of
Number of working days that have passed in the current month
Date - Number of
Number of working days that have passed in the current year
Date - Number of
Number of working hours between 2 dates
Time - Number of
Number of working hours between 2 times
Time - Number of
Number of years between 2 dates
Date - Number of Years
Return a date in a particular format
Date - Display
Return a date in US date format
Date - Display
Return a persons age in years
Date - Display
Return the 3rd monday in a month
Date - Display
Return the business days
Date - Display
Return the current date
Date - Display
Return the current date and time
Date - Display
Return the current day
Date - Display
Return the current month
Date - Display
Return the current quarter
Date - Display
Return the current time
Time - Display
Return the current year
Date - Display
Return the date from a date and time
Date - Display
Return the date of the monday in the current week
Date - Display
Return the date of the monday in the next week
Date - Display
Return the date of the monday in the previous week
Date - Display
Return the day from date
Date - Return
Return the day name
Date - Display
Return the first business day of the year
Date - First
Return the first day of the current month
Date - First
Return the first day of the next month
Date - First
Return the first day of the previous month
Date - First
Return the first monday of the current month
Date - First
Return the first monday of the next month
Date - First
Return the first monday of the previous month
Date - First
Return the first weekday of the year
Date - First
Return the last business day of the year
Date - Last
Return the last day of the current month
Date - Last
Return the last day of the next month
Date - Last
Return the last day of the previous month
Date - Last
Return the last monday of the current month
Date - Last
Return the last monday of the next month
Date - Last
Return the last monday of the previous month
Date - Last
Return the last weekday of the year
Date - Last
Return the month from a date
Date - Return
Return the next business day
Date - Display
Return the next working day
Date - Display
Return the nth business day of the year
Date - Return
Return the nth day of the year
Date - Return
Return the number corresponding to a given month
Date - Display
Return the time elapsed between 2 times
Time - Display
Return the time from a date and time
Time - Display
Return the time rounded to the nearest 15 minutes
Time - Display
Return the week number of the current date
Date - Display
Return the working hours between 2 dates
Time - Display
Return the working hours between 2 times
Time - Display
Return the year from a date
Date - Return
Subtract days from a date
Date - Add or Subtract
Subtract hours from a time
Date - Add or Subtract
Subtract minutes from a time
Date - Add or Subtract
Subtract months from a date
Date - Add or Subtract
Subtract seconds from a time
Date - Add or Subtract
Subtract weeks from a date
Date - Add or Subtract
Subtract years from a date
Date - Add or Subtract
Test if a year is a leap year
Date - Test

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