↓ Skip to Main Content
Excelabcd

Main Navigation

  • Excel functions
    • Excel Functions
    • Exercise
      • COUNT Functions Exercise
      • SUM Functions Exercise
      • LOOKUP Functions Exercise
  • Excel Features
    • Protect Workbook
    • Hyperlink
    • Text to Columns
    • Freeze Panes
    • Conditional Formatting
    • Charts
    • PivotTable
    • Filter
    • Data Validation
    • Format Cells
  • Excel++
    • Shortcuts
    • 100+ formulas
    • Short Tips
    • Free Sample Excel Data
    • Excel Templates
      • Calculator Templates
      • Misc Templates
  • VBA
    • What is VBA?
    • Learn VBA step by step
    • Posts related VBA
  • Blog
  • Buy Resources
    • Buy Ebook
    • Buy Premium Templates
  • Excel Courses
    • Basic Excel Course
Excelabcd

Off Canvas Menu

  • Excel functions
    • Excel Functions
    • Exercise
      • COUNT Functions Exercise
      • SUM Functions Exercise
      • LOOKUP Functions Exercise
  • Excel Features
    • Protect Workbook
    • Hyperlink
    • Text to Columns
    • Freeze Panes
    • Conditional Formatting
    • Charts
    • PivotTable
    • Filter
    • Data Validation
    • Format Cells
  • Excel++
    • Shortcuts
    • 100+ formulas
    • Short Tips
    • Free Sample Excel Data
    • Excel Templates
      • Calculator Templates
      • Misc Templates
  • VBA
    • What is VBA?
    • Learn VBA step by step
    • Posts related VBA
  • Blog
  • Buy Resources
    • Buy Ebook
    • Buy Premium Templates
  • Excel Courses
    • Basic Excel Course

Tag: WEEKDAY

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

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

Pushpendu Roy Karmakar Feb 28, 2018 Tagged with CONDITIONAL FORMATTING, WEEKDAY

This is a project schedule format where I have a list of dates and works. I …

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

Lesson#31: Current dynamic calendar for whole Year
Excel Features, Excel Funtions

Lesson#31: Current dynamic calendar for whole Year

Pushpendu Roy Karmakar Jan 20, 2018 Tagged with DATA VALIDATION, DATE, DAY, IF, IFERROR, MONTH, TODAY, WEEKDAY, YEAR

This post is a continuation of one of my previous posts Lesson#27: How to make a …

Lesson#31: Current dynamic calendar for whole Year Read more →

Lesson#27: How to make a calendar in excel without VBA
Excel for Office, Excel Tricks

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

Pushpendu Roy Karmakar Jan 4, 2018 Tagged with DATA VALIDATION, DATE, IF, IFERROR, MONTH, WEEKDAY, YEAR

In this post, we will learn to make a calendar which will take input of month …

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

Lesson#26: What is WEEKDAY in Excel?
Excel Funtions

Lesson#26: What is WEEKDAY in Excel?

Pushpendu Roy Karmakar Jan 2, 2018 Tagged with WEEKDAY

WEEKDAY is a function that returns the day of the week corresponding to a date. from …

Lesson#26: What is WEEKDAY in Excel? Read more →

Microsoft365 for Business

AND CALCULATOR CHART CONDITIONAL FORMATTING COUNT COUNTBLANK COUNTIF COUNTIFS DATA VALIDATION DATE DAY FILTER FIND FORMAT CELLS HOUR IF IFERROR INDEX LEFT LEN MATCH MAX MID MIN MINUTE MOD MONTH NOT NOW PIVOTTABLE PROTECT SHEET recover RIGHT ROUND SECOND SHORTCUTS SUBSTITUTE SUM SUMIF SUMIFS TEXT TEXT TO COLUMNS TODAY VLOOKUP YEAR

Microsoft365 for Business

AND CALCULATOR CHART CONDITIONAL FORMATTING COUNT COUNTBLANK COUNTIF COUNTIFS DATA VALIDATION DATE DAY FILTER FIND FORMAT CELLS HOUR IF IFERROR INDEX LEFT LEN MATCH MAX MID MIN MINUTE MOD MONTH NOT NOW PIVOTTABLE PROTECT SHEET recover RIGHT ROUND SECOND SHORTCUTS SUBSTITUTE SUM SUMIF SUMIFS TEXT TEXT TO COLUMNS TODAY VLOOKUP YEAR

Footer Menu

  • Home
  • About
  • Contact
  • Privacy Policy

Footer Menu

  • Home
  • About
  • Contact
  • Privacy Policy
Copyright © 2026 Excelabcd | Powered by Responsive Theme
Copyright © 2026 Excelabcd | Powered by Responsive Theme
Loading…