Short Tips#0018: Know the functions DAY, MONTH and YEAR
Tag: DAY
Lesson#56: How to make birthday reminder in excel
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 »
Lesson#52: Let’s check your lifeline with Excel
Just a different exercise of excel. I have downloaded a listed country-wise average life expectancy by WHO. Let’s check where are we in our lifeline by this sheet. Let’s take an input of the date of birth from the user. …
Lesson#31: Current dynamic calendar for whole Year
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#15: Know about functions DATE, DAY, MONTH, YEAR
In this post, we will talk about the functions DATE, DAY, MONTH, and YEAR. DATE function converts date, month, and year values into single-line date format. Let me show you an example. I have written DAY, MONTH, and YEAR for …
Lesson#15: Know about functions DATE, DAY, MONTH, YEAR Read more »