Home › Learn Excel › Lesson 13
Build dates, work out ages and durations, find the end of a month and count working days.
DATE builds a real date from a year, a month and a day, always in that order. Turn the year, month and day into one date, in D2TODAY returns today's date and updates every day. It needs nothing between the brackets. Show today's date in B2DATEDIF counts the full years between the date of birth and TODAY(), so the age updates by itself. Work out in C2 how old Sam is todayEOMONTH returns the last day of a month. A 0 at the end means the same month, 1 means next month. Find the last day of the month of the invoice date, in B2NETWORKDAYS counts the weekdays between two dates, the first and last day included. Weekends don't count. Count the working days between the two dates, in C2