How To Create A 2025 Calendar In Excel Sheet Formula. See the formula below for adding days to a date in excel using the date function: For example, to find the serial number.

= date ( year (c3), month (c3), day (c3) + d3) the year function takes. I call it the most efficient method to create.