↓ 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: DATE

Lesson#107: How did I add MS Project features to the Excel project schedule
Excel for Office, Excel Tricks

Lesson#107: How did I add MS Project features to the Excel project schedule

Pushpendu Roy Karmakar Sep 17, 2018 Tagged with COUNTIF, DATE, EOMONTH, FIND, FORMULATEXT, IFERROR, INDIRECT, LEN, MID, MONTH, NOT, SUBSTITUTE, WORKDAY.INTL, YEAR

Here I will discuss a long topic about Excel Gantt chart making. I will show how …

Lesson#107: How did I add MS Project features to the Excel project schedule Read more →

Lesson#87: How to make month wise auto-updating program schedule
Excel for Office, Excel Tricks

Lesson#87: How to make month wise auto-updating program schedule

Pushpendu Roy Karmakar Jun 26, 2018 Tagged with CONDITIONAL FORMATTING, DATE, EOMONTH, FORMAT CELLS, IF, MONTH, YEAR

Previously I have discussed in a post Lesson#39: Cool tricks to make automatically updating Gantt chart …

Lesson#87: How to make month wise auto-updating program schedule Read more →

Lesson#52: Let’s check your lifeline with Excel
Excel Funtions, Excel general tips

Lesson#52: Let’s check your lifeline with Excel

Pushpendu Roy Karmakar Feb 25, 2018 Tagged with DATA VALIDATION, DATE, DAY, FORMAT CELLS, IF, IFERROR, MONTH, ROUND, VLOOKUP, YEAR, YEARFRAC

Just a different exercise of excel. I have downloaded a listed country-wise average life expectancy by …

Lesson#52: Let’s check your lifeline with Excel 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#20: Making an age calculator in excel with DATEDIF function
Excel Funtions

Lesson#20: Making an age calculator in excel with DATEDIF function

Pushpendu Roy Karmakar Dec 20, 2017 Tagged with CONCATENATE, DATA VALIDATION, DATE, DATEDIF, TODAY

In this post, we will talk about the formula DATEDIF(). This the formula is used to …

Lesson#20: Making an age calculator in excel with DATEDIF function Read more →

Lesson#15: Know about functions DATE, DAY, MONTH, YEAR
Excel Funtions

Lesson#15: Know about functions DATE, DAY, MONTH, YEAR

Pushpendu Roy Karmakar Dec 10, 2017 Tagged with DATE, DAY, MONTH, YEAR

In this post, we will talk about the functions DATE, DAY, MONTH, and YEAR. DATE function …

Lesson#15: Know about functions DATE, DAY, MONTH, YEAR 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…