BetterSolutions.com
BetterSolutions.com
Resources
Microsoft Office Word
VBA Programming
C# Programming
JavaScript Programming
Add-ins
Office Add-ins for Excel
Office Add-ins for Word
Consultancy
Macros, Templates and EUDAs
TypeScript and JavaScript
Development
Office JS Add-ins and Scripts
End User Programming
Support
VSTO and .NET Migration
Troubleshooting
Training
Microsoft 365 Integration
Please Contact Us Today for a FREE Consultation
Excel
Add-ins
Best Practices
Cells Ranges
Charts
Conditional Format
Data Analysis
Data Validation
Dates Times
Search Excel ...
Functions
User Defined
Formulas
Formatting
Finance
Illustrations
Importing
Layout
Our Services ...
Macros
Named Ranges
Options
Pivot Tables
Protection
Python
Reviewing
Ribbon
Find Add-ins ...
Rows Columns
Shortcut Keys
Tables
Templates
Track Changes
Workbooks
Worksheets
XML
Contact Us ...
Word
Add-ins
Bookmarks
Building Blocks
Bullets
Characters
Charts
Content Controls
Design
Search Word ...
Documents
Fields
Illustrations
Importing
Layout
Macros
Mailings
Numbering
Our Services ...
Options
Outlines
Pages
Paragraphs
Protection
References
Reviewing
Ribbon
Find Add-ins ...
Sections
Shortcut Keys
Styles
Tables
Templates
Text Boxes
Track Changes
XML
Contact Us ...
PowerPoint
Add-ins
Animation
Bullets
Characters
Charts
Design
Handouts
Illustrations
Search PowerPoint ...
Importing
Layout
Macros
Notes
Numbering
Options
Outlines
Paragraphs
Our Services ...
Presentations
Protection
References
Reviewing
Ribbon
Sections
Shortcut Keys
Slide Show
Find Add-ins ...
Slides
Tables
Templates
Text Boxes
Track Changes
Transitions
Video
XML
Contact Us ...
Outlook
Add-ins
Address Book
Alerts
Appointments
Calendar
Contacts
Events
Exchange
Search Outlook ...
Folders
Forms
Groups
HTML
Illustrations
Importing
Journal
Macros
Our Services ...
Mail
Meetings
Notes
OneDrive
OneNote
Options
People
Proofing
Find Add-ins ...
Ribbon
Rules
Search
SharePoint
Shortcut Keys
Tasks
Web Client
XML
Contact Us ...
VBA
Add-ins
Arrays
Best Practices
Class Modules
Code Snippets
Collections
Controls
Databases
Search VBA ...
Data Types
Dates Times
Debugging
Enumerations
Error Handling
Events
Files Directories
Functions
Our Services ...
Macros
MsgBox
Numbers
Options
References
Ribbon
Shortcut Keys
SQL
Find Add-ins ...
Strings
Subroutines
Syntax
Userforms
Variables
Visual Basic Editor
Web Interaction
XML
Contact Us ...
C#
.NET Library
Arrays
Best Practices
Classes
Collections
Databases
Data Types
Dates Times
Search C# ...
Debugging
Excel Interop
Error Handling
Files Directories
Generics
Interfaces
MessageBox
Numbers
Our Services ...
Projects
Serialization
Strings
Structures
Syntax
Threading
Variables
VBA Migration
Find Add-ins ...
Visual Studio
VSTO Add-ins
Web Add-ins
Web Development
Web Services
Windows Forms
WPF Forms
XML
Contact Us ...
JS
Arrays
Custom Functions
Data Types
Dates Times
Debugging
Dialog Boxes
Error Handling
Excel API
Search JavaScript ...
Express Backend
Fluent UI
Functions
HTML Pages
Microsoft Graph
Node JS Runtime
Numbers
Objects
Our Services ...
Office Add-ins
Office Events
Office Manifest
Office Scripts
Outlook API
PowerPoint API
React Library
Ribbon Commands
Find Add-ins ...
Strings
Syntax
Task Panes
TypeScript
Variables
Visual Studio Code
Word API
Yeoman Generator
Contact Us ...
Software Development Services
High Value Consultancy
VBA Templates and Macros
Office Scripts and EUDAs
JavaScript Office-JS Migration
Bespoke Office Add-ins
Long-Term Technical Support
Contact Us ...
Excel
>
Formulas
Microsoft Excel
Formulas
User FAQs ...
Shortcut Keys ...
Formula Auditing ...
Inserting ...
Complete List
Categories ...
Counting
Summing
Lookup
Conditional
Date & Time
Formatting
Number
Statistical
Text
Filtering
Data Validation
Other
Counting Formulas ...
Summing Formulas ...
Lookup Formulas ...
Text Formulas ...
Calculation ...
Error Checking ...
Updates ...
Code - TypeScript
Code - VBA ...
Updated: 02 May 2025
02 May 2025
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 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
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
© 2025 Better Solutions Limited.
All Rights Reserved.
© 2025
Better Solutions Limited
Top