COUNTBLANK & DATEDIF Functions in Microsoft Excel
Автор: Concept Clear With AP
Загружено: 2026-02-17
Просмотров: 2
Описание:
COUNTBLANK Function – Count Empty Cells in Excel
The COUNTBLANK function counts the number of empty (blank) cells in a selected range.
👉 Returns the total number of blank cells.
🎯 Use Cases
Checking missing data
Audit data cleaning
Attendance sheets
Incomplete entries detection
DATEDIF Function
📌 Title
DATEDIF Function – Calculate Difference Between Two Dates
📖 Description
The DATEDIF function calculates the difference between two dates in years, months, or days.
(Note: It is a hidden function but works in Excel.)
=DATEDIF(start_date, end_date, unit)
| Unit | Meaning |
| ---- | ------------------------------- |
| "Y" | Years |
| "M" | Months |
| "D" | Days |
| "YM" | Months (excluding years) |
| "YD" | Days (excluding years) |
| "MD" | Days (excluding months & years) |
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
