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 weekendsPlaceholder
Add days to a date excluding weekends and changing the days of the weekendPlaceholder
Add days to a date excluding weekends and public holidaysPlaceholder
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 datePlaceholder
Add working days to a date changing the days of the weekendPlaceholder
Add working days to a date excluding public holidaysPlaceholder
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 between 2 dates ignoring months and yearsDate - Number of Days
Number of days between 2 dates ignoring yearsDate - 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 months years from a dateDate - 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 and days between 2 datesDate - Number of Months
Number of months between 2 datesDate - Number of Months
Number of months between 2 dates ignoring days and yearsDate - Number of Months
Number of months weeks days between 2 datesDate - Number of Months
Number of occurrences of a particular day of the weekDate - Number of
Number of weekend daysDate - Number of Days
Number of weekend days between 2 datesDate - Number of Days
Number of weekend days in a particular monthDate - Number of Days
Number of weekend days in a particular yearDate - Number of Days
Number of weeks and days between 2 datesDate - Number of Weeks
Number of weeks between 2 datesDate - Number of Weeks
Number of working daysPlaceholder
Number of working days between 2 datesPlaceholder
Number of working days in a particular monthPlaceholder
Number of working days in a particular yearPlaceholder
Number of working days left in the current monthPlaceholder
Number of working days left in the current yearPlaceholder
Number of working days that have passed in the current monthPlaceholder
Number of working days that have passed in the current yearPlaceholder
Number of working hours between 2 datesTime - Number of Hours
Number of working hours between 2 timesTime - Number of Hours
Number of years and days between 2 datesDate - Number of Years
Number of years between 2 datesDate - Number of Years
Number of years months days between 2 datesDate - Number of Years
Number of years months days from a dateDate - 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 a persons age in years months daysDate - 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 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 current quarterDate - 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 monthDate - Last
Return the last weekday of the yearDate - Last
Return the month from a dateDate - Return
Return the next business dayDate - Return
Return the next fridayDate - Return
Return the next mondayDate - Return
Return the next working dayDate - Return
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 previous fridayDate - Return
Return the previous mondayDate - Return
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 - Return
Return the working hours between 2 datesTime - Display
Return the working hours between 2 timesTime - Display
Return the year from a dateDate - Return
Subtract business days from a dateDate - Add or Subtract
Subtract business days from a date changing the days of the weekendDate - Add or Subtract
Subtract business days from a date excluding public holidaysDate - Add or Subtract
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
Placeholder
Add days to a date excluding weekends and changing the days of the weekend
Placeholder
Add days to a date excluding weekends and public holidays
Placeholder
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
Placeholder
Add working days to a date changing the days of the weekend
Placeholder
Add working days to a date excluding public holidays
Placeholder
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 between 2 dates ignoring months and years
Date - Number of Days
Number of days between 2 dates ignoring years
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 months years from a date
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 and days between 2 dates
Date - Number of Months
Number of months between 2 dates
Date - Number of Months
Number of months between 2 dates ignoring days and years
Date - Number of Months
Number of months weeks days 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 Days
Number of weekend days between 2 dates
Date - Number of Days
Number of weekend days in a particular month
Date - Number of Days
Number of weekend days in a particular year
Date - Number of Days
Number of weeks and days between 2 dates
Date - Number of Weeks
Number of weeks between 2 dates
Date - Number of Weeks
Number of working days
Placeholder
Number of working days between 2 dates
Placeholder
Number of working days in a particular month
Placeholder
Number of working days in a particular year
Placeholder
Number of working days left in the current month
Placeholder
Number of working days left in the current year
Placeholder
Number of working days that have passed in the current month
Placeholder
Number of working days that have passed in the current year
Placeholder
Number of working hours between 2 dates
Time - Number of Hours
Number of working hours between 2 times
Time - Number of Hours
Number of years and days between 2 dates
Date - Number of Years
Number of years between 2 dates
Date - Number of Years
Number of years months days between 2 dates
Date - Number of Years
Number of years months days from a date
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 a persons age in years months days
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 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 current quarter
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 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 - Return
Return the next friday
Date - Return
Return the next monday
Date - Return
Return the next working day
Date - Return
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 previous friday
Date - Return
Return the previous monday
Date - Return
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 - Return
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 business days from a date
Date - Add or Subtract
Subtract business days from a date changing the days of the weekend
Date - Add or Subtract
Subtract business days from a date excluding public holidays
Date - Add or Subtract
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

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