In the dynamic world of Excel, tracking real-time information is often crucial. The Excel NOW and TODAY functions are your trusty companions for creating real-time timestamps that update automatically. These functions are indispensable when you need to keep records of …
Lesson#237: Excel NOW and TODAY Functions: Real-Time Timestamps Simplified Read more →
Hello readers! In this post, we shall learn about the 25 most useful Excel Functions everyone needs to know. Newcomers who start to learn Microsoft Excel gets easily confused with hundreds of excel formulas and functions. So today we shall …
Lesson#155: 25 most useful Excel Functions everyone needs to know Read more →
Here I am having an employee database and I have to make a birthday reminder in excel from it. It needs a few tricks to make it. I have inserted two columns beside the DOB column, Upcoming Birthdays this Month and Birthday …
Lesson#56: How to make birthday reminder in excel Read more →
This post is a continuation of one of my previous posts Lesson#27: How to make a calendar in excel without VBA. I will show how to modify this calendar a little more and make it a current dynamic calendar for …
Lesson#31: Current dynamic calendar for whole Year Read more →
Lesson 25 is a discussion about the function WEEKNUM. This function returns the week number in a year. Syntax of this function is WEEKNUM(serial_number,[return_type]) where serial_number is a date and [return_type] is optional. A number that determines on which day the …
Lesson#25: Function WEEKNUM has a good use for construction people Read more →
In this post, we will talk about the formula DATEDIF(). This the formula is used to get the difference in days, months, or years between two dates. In excel we are unable to find any help with the formula but …
Lesson#20: Making an age calculator in excel with DATEDIF function Read more →
Lesson#16 will introduce you to some more new function TODAY, NOW, HOUR, MINUTE, SECOND, YEARFRAC. Function TODAY returns the current date formatted as a date. Function NOW returns the current date and time formatted as date and time. HOUR(serial_number) returns the hour as a …
Lesson#16: Know about function TODAY, NOW, HOUR, MINUTE, SECOND, YEARFRAC Read more →
