This is a project schedule format where I have a list of dates and works. I need to color all the Sundays in the list of dates and for that, I will use a simple trick. Select all the dates …
Lesson#53: Simple trick to color all the Sundays in the list of dates at once 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 →
In this post, we will learn to make a calendar which will take input of month from 1 (JAN) to 12 (DEC) and year in numeric format and show the whole month calendar. 1st Step: Make a 2×2 table like …
Lesson#27: How to make a calendar in excel without VBA Read more →
WEEKDAY is a function that returns the day of the week corresponding to a date. from 1 (Sunday) to 7 (Saturday) representing the day of the week of a date. Syntax of the function is WEEKDAY(serial_number,[return_type]) serial_number is a sequential number …