Date Formulas

Add business days to a dateDate - Add or Subtract
Add days to a dateDate - Add or Subtract
Add days to a date avoiding weekendsDate - Add or Subtract
Add days to a date excluding certain daysDate - Add or Subtract
Add days to a date excluding weekendsDate - Add or Subtract
Add days to a date excluding weekends and public holidaysDate - Add or Subtract
Add months to a dateDate - Add or Subtract
Add workdays to a dateDate - Add or Subtract
Add years to a dateDate - Add or Subtract
Convert a date string to a date valueDate - Convert
Display a date in a particular formatDate - Display
Display a date in US date formatDate - Display
Display a persons age in yearsDate - Display
Display the 3rd Monday in a monthDate - Display
Display the current dateDate - Display
Display the current date and timeDate - Display
Display the current dayDate - Display
Display the current monthDate - Display
Display the current quarterDate - Display
Display the current yearDate - Display
Display the date from date and timeDate - Display
Display the date of the Monday in the current weekDate - Display
Display the day nameDate - Display
Display the next business dayDate - Display
Display the next working dayDate - Display
Display the number corresponding to a given monthDate - Display
Display the week number of the current dateDate - Display
First day of the current monthDate - First
First day of the previous monthDate - First
First Monday of the next monthDate - First
First Monday of the previous monthDate - First
First weekday of the yearDate - First
Last day of the current monthDate - Last
Last day of the previous monthDate - Last
Last Monday of the next monthDate - Last
Last Monday of the previous monthDate - Last
Last weekday of the yearDate - Last
Number of business daysDate - Number of Days
Number of days between 2 datesDate - 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 weekdaysDate - Number of
Number of weekdays between 2 datesDate - Number of
Number of weekdays in a particular monthDate - Number of
Number of weekdays left in the current monthDate - Number of
Number of weekdays left in the current yearDate - Number of
Number of weekdays that have passed in the current monthDate - Number of
Number of weekdays that have passed in the current yearDate - 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 workdaysDate - Number of
Number of workdays between 2 datesDate - Number of
Number of workdays in a particular monthDate - Number of
Number of years between 2 datesDate - Number of Years
Subtract days from a dateDate - Add or Subtract
Subtract months from a dateDate - Add or Subtract
Subtract years from a dateDate - Add or Subtract
Test if year is a leap yearDate - Test

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