Holiday Weather - We provide weather averages for Florida Keys USA, average day and night temperature, sunshine hours, rainfall and sea temperature Holiday Weather Search :
The Microsoft Excel DAY function returns the day of the month (a number from 1 to 31) given a date value. The DAY function is a built-in function in Excel that is categorized as a Date/Time Function. It can be used as a worksheet function (WS) and a VBA function (VBA) in Excel. As a worksheet function, the DAY function can be entered as part of a formula in a cell of a worksheet. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.
The Days360 Function in Excel. When you want to work out how many days there are between two dates, the function to use is Days360( ). We want to work out how many days there are between the 15th of April 2016 and the 3rd of May 2016. So click inside cell C2 and do the following: Click on the Formulas tab at the top of Excel.