Archive for DAY function
The DAY function extracts the day as a number from an Excel date. Formula in cell C3: =DAY(B3) Excel Function […]
Tesh asks: How easy is it to modify this for recurring tasks (weekdays, weekly, monthly, quarterly and yearly) and maybe […]
Calculate last date of a given month
The formula in cell C3 calculates the last date for the given month and year in cell B3. =DATE(YEAR(B3), MONTH(B3)+1, […]
