Tag: WEEKDAY

Lesson#53: Simple trick to color all the Sundays in list of dates at once

This is a project schedule format where I have list of dates and works. I need to color all the Sundays in list of dates and for that I will use a simple trick. Select all the dates then go

Tagged with: ,

Lesson#31: Current dynamic calendar for whole Year

This post is continuation for 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 the whole

Tagged with: , , , , , , , ,

Lesson#27: How to make a calendar in excel without VBA

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

Tagged with: , , , , , ,

Lesson#26: What is WEEKDAY?

WEEKDAY is a function which 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 in

Tagged with:
Top