Home
BetterSolutions.com
Online Documentation
Microsoft Office Excel
Microsoft Office Word
JavaScript Programming
VBA Programming
C# Programming
Microsoft Office Excel
Workbooks
Worksheets
Rows Columns
Cells Ranges
Data Validation
Data Analysis
Pivot Tables
Power Query
Search Excel ...
Functions
User Defined
Formulas
Dynamic Formulas
Reviewing
Track Changes
Named Ranges
Conditional Format
Microsoft Word
Tables
Charts
Dates Times
Formatting
Illustrations
Layout
Importing
XML
Microsoft PowerPoint
Ribbon
Options
Shortcut Keys
Protection
Add-ins
Macros
Templates
Quant Finance
Microsoft Outlook
Microsoft Office Excel
Worksheet Functions List
Ribbon Tabs Explained
Keyboard Shortcut Keys
Best Practices
Search Excel ...
VBA Programming
Visual Basic Editor
Best Practices
Macros
Syntax
Arrays
Collections
Error Handling
Debugging
Search VBA ...
Data Types
Variables
Strings
Numbers
Dates
Text Files
Directories
XML
Questions
Functions
Subroutines
MsgBox
InputBox
Userforms
Controls
Events
Databases
JS Programming
Ribbon
Options
Shortcut Keys
Enumerations
Class Modules
References
Web Services
SQL
C# Programming
VBA Programming
Complete Functions List
Recording Macros
Syntax And Loops
Best Practices
Search VBA ...
Bespoke Development
Office Add-in Development
JavaScript Office Add-ins
VSTO and C# Integration
Macros and VBA Programming
High Value Consultancy
Get In Touch
Excel
>
Formulas
Microsoft Excel
Formulas
User FAQs ...
Shortcut Keys ...
Troubleshooting ...
Different Error Types ...
Complete List
Categories ...
Counting
Summing
Lookup
Conditional
Date & Time
Formatting
Number
Statistical
Text
Filtering
Data Validation
Other
Counting Formulas
Summing Formulas
Lookup Formulas
Inserting ...
Calculation ...
Auditing ...
Error Checking ...
Dynamic Formulas ...
Array Formulas ...
Updates ...
Code - TypeScript
Code - VBA ...
Updated: 28 March 2023
28 March 2023
Date & Time Formulas
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 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 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 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 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 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
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 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 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 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 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 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
© 2023 Better Solutions Limited.
All Rights Reserved.
© 2023
Better Solutions Limited
Top