Age from DOB
=DATEDIF(B2,TODAY(),"Y")
B2 = date of birth
Calculates completed age.
Date Formula ToolsDate Formula Date Formula Date Formula Date Formula Date Formula Date Formula Date Formula Date Formula
Date Formula Helper
Find date formulas for age, days between dates, month names, quarters, financial year, week number, and end-of-month reporting.
Days Between Dates
=C2-B2
B2 = start date, C2 = end date
Returns number of days between two dates.
Add Days to Date
=B2+C2
B2 = date, C2 = days to add
Adds a number of days to a date.
Month Name
=TEXT(B2,"mmmm")
B2 = date
Returns the full month name.
Quarter
="Q"&ROUNDUP(MONTH(B2)/3,0)
B2 = date
Returns Q1, Q2, Q3, or Q4.
Financial Year
=IF(MONTH(B2)>=4,YEAR(B2)&"-"&YEAR(B2)+1,YEAR(B2)-1&"-"&YEAR(B2))
B2 = date
Creates an April-to-March financial year label.
Week Number
=WEEKNUM(B2)
B2 = date
Returns the week number of the year.
End of Month
=EOMONTH(B2,0)
B2 = date
Returns the last day of the same month.
Date formulas need real dates
Excel date formulas depend on real date values. If exported dates are stored as text, formulas such as DATEDIF, EOMONTH, WEEKNUM, and MONTH may return errors or wrong results. Clean date columns first, keep a consistent format, and use helper columns when preparing business reports.
Date formula FAQ
What are common Excel date formulas?
Common date formulas include DATEDIF for age, EOMONTH for month end, TEXT for month names, WEEKNUM for week number, and arithmetic formulas for days between dates.
How do I calculate age from DOB?
Use =DATEDIF(B2,TODAY(),"Y") when the date of birth is in B2.
Why do date formulas fail?
Date formulas often fail when dates are stored as text instead of real Excel dates.
Related Excel tools
Formula Tools
Excel Formula Finder
Search business problems like GST, profit margin, attendance, age, commission, and get the right Excel formula.
EcommerceEcommerce Export Cleaner
Clean messy CSV exports, emails, phone numbers, currency symbols, blank rows, and duplicate order IDs.
HRSalary & Attendance Helper
Create HR formulas for present days, absent days, attendance percentage, salary deduction, and overtime.