Date & Time functions

DAYS() function

Return the number of days between two dates

=DAYS(end_date,start_date)

Date & Time Functions

Latest Additions

TEXTJOIN() function 26 March 2022

REPLACE() function 26 March 2022

TEXT() function 26 March 2022

RANK.AVG() function 25 March 2022

CONCAT() function 22 March 2022

CHAR() function 21 March 2022

Register (for free!) or Login to access bonus materials

About xlsnippets

Learn how to master functions, charts, pivot tables and more using Excel for Microsoft Office 365. Simple instructions and embedded spreadsheets help you practise the basics.

Latest Updates

TEXTJOIN() function 26 March 2022

REPLACE() function 26 March 2022

TEXT() function 26 March 2022

RANK.AVG() function 25 March 2022

CONCAT() function 22 March 2022

Coming soon

xlsnippets.com is currently in beta version. More functions and bonus content for registered users will be added weekly. Detailed training courses with additional downloadable resources are also on the horizon!

DATE() function

Return the serial number of a particular date

=DATE (year, month, day)

YEAR, MONTH, DAY() functions

Return the year, month or day component of a date

=YEAR(serial_number), =MONTH(serial_number), =DAY(serial_number)

TODAY() function

Return the serial number of the current date

=TODAY()

NOW() function

Return the serial number of the current date and time

=NOW()