Excel TODAY

Conditional Format Dates earlier than or Greater Than Today

This post will guide you how to use conditional formatting to identify dates earlier than or greater than today in Excel. How do I highlight dates greater than or less than today or a certain date with conditional formatting in Excel. How to format cell if cell contains date less than or greater than today… read more »

Insert Countdown Timer

This post will guide you how to create a countdown timer in an Excel Worksheet. How do I insert a countdown timer in Excel. How to create a countdown timer clock in Excel. Create Countdown Timer Assuming that you want to create a countdown timer until 2020/1/1 in Excel, you can do the following steps:… read more »

Highlight the Dates if its over a year

This post will guide you how to highlight the dates that are over 1 year in excel. How do I highlight the dates over a year old using conditional formatting feature in excel. How to use conditional formatting to highlight if the dates are over a year in excel. How to highlight cells color when… read more »

Highlight Rows If Dates Have Passed

This post will guide you how highlight rows if the dates in cells have passed from now in your worksheet. How do I highlight rows if dates have passed with the Conditional Formatting feature in excel. Highlight Rows If Dates Have Passed Assuming that you have a worksheet that have a bunch of columns and… read more »

Excel TODAY Function

This post will guide you how to use Excel TODAY function with syntax and examples in Microsoft excel. Description The Excel TODAY function returns the serial number of the current date. So you can get the current system date from the TODAY function. The serial number is the date-time code used by Excel for date… read more »

How to Calculate Days, Weeks, Months and Years between Two Dates

This post will teach you how to calculate days, weeks, months and years between two dates in excel. How do I count the number of days, weeks, months and years between 2 dates in excel. Calculate days between two dates If you want to calculate the difference in days between two dates, you can use… read more »

How to Add / Subtract Days, Months and Years to Date

This post will guide you how to add or subtract a given number of days to a date in excel. How to add or subtract weeks to a date using excel formula. How to add or subtract a certain number of months to a date using excel formula. How to add or subtracts a given… read more »

How to calculate age from date of birth

This post explains that how to get age from the date of birth in a Cell. How to calculate birthdate to age using formulas in Excel. How to convert the birth of date to age quickly in Excel. Calculate age from date of birth If you have a table that contains birthdate data in a… read more »

Excel Nexted IF Functions (Statements) Tutorial (15 IF Formulas examples)

This tutorial will guide you how to use nested Excel IF function¬† (include multiple If statements in excel formula) with syntax and provide about 15 nested IF formula examples with the detailed explanation in Microsoft excel. Nested If function Description Nested If Function Syntax Examples of Nested IF function in Excel Nested If Functions(Statements) Order… read more »

Sidebar