=DAYS() ☆

⬇ Download Sample Workbook

A dedicated .xlsx for =DAYS() with Persian sample data & live formulas — open in Excel and practice.

• Sheet “Sample” — data table + formula in place
• Sheet “Guide” — syntax, arguments & tips from this page
• Instant & secure (token + rate limit)

⇪ Share

Send this function to friends

🧠 🧠 Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

▣ Examples

§ Remarks

• If both date arguments are numbers, DAYS uses EndDate–StartDate to calculate the number of days in between both dates.
• If either one of the date arguments is text, that argument is treated as DATEVALUE(date_text) and returns an integer date instead of a time component.
• If date arguments are numeric values that fall outside the range of valid dates, DAYS returns the #NUM! error value.
• If date arguments are strings that cannot be parsed as valid dates, DAYS returns the #VALUE! error value.

✦ Tips

• If both date arguments are numbers, DAYS uses EndDate–StartDate to calculate the number of days in between both dates.
• If either one of the date arguments is text, that argument is treated as DATEVALUE(date_text) and returns an integer date instead of a time component.

⚠ Common Errors

⇄ Related Functions

Share your thoughts — visible after admin approval

✍️ Add comment / question

Comment Question Answer ✕

Name * Email (optional)

Message * 10–1000

Security code *

↻ New image

📩 Submit — will appear after approval

🔒 Your comment will be published after review.