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 and changing the days of the weekend*
Placeholder |
Add days to a date excluding weekends and public holidays*
Placeholder |
Add days to a date excluding weekends*
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 decimal hours to time*
Placeholder |
Add decimal minutes to time*
Placeholder |
Add decimal seconds to time*
Placeholder |
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 changing the days of the weekend*
Placeholder |
Add working days to a date excluding public holidays*
Placeholder |
Add working days to a date*
Placeholder |
Add years to a date
Date - Add or Subtract |
Convert a date string to a date value
Date - Convert |
Convert decimal hours to time
Time - Convert |
Convert decimal minutes to time
Time - Convert |
Convert decimal seconds to time
Time - Convert |
Convert hours to time*
Placeholder |
Convert minutes to time*
Placeholder |
Convert seconds to time*
Placeholder |
Convert time to hours
Time - Convert |
Convert time to minutes
Time - Convert |
Convert time to seconds
Time - Convert |
Convert time to time zone
Time - Convert |
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 business days*
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 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 weekend days*
Placeholder |
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 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 days*
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 from a date string
Date - Display |
Return a date in a particular format
Date - Display |
Return a date in US date format
Date - Display |
Return a list of random dates in a particular range
Date - Display |
Return a persons age in years
Date - Display |
Return a persons age in years months days
Date - Display |
Return random dates in a particular range
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 from a date string
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 a 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 current quarter
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 day of the previous quarter
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 day of the previous quarter
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 most recent Friday*
Date - Return |
Return the most recent Monday*
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 a month
Date - Return |
Return the nth day of a week
Date - Return |
Return the nth day of a year
Date - Return |
Return the number corresponding to a given month
Date - Display |
Return the previous business day
Date - Return |
Return the previous Friday
Date - Return |
Return the previous Monday
Date - Return |
Return the previous working day
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 cell is between 2 dates
Date - Test |
Test if a date is in a particular range
Date - Test |
Test if a month has 30 days
Date - Test |
Test if a month has 31 days
Date - Test |
Test if a year is a leap year
Date - Test |