New Contributor
How can I use this Equation in Excel
There is some wrong
Please help me
3 Replies


Please attach a copy of your workbook (without sensitive information) instead of a photo.

Not problem


Most probably you have texts which represent the dates, not actual dates. Actually dates in Excel are integer numbers formatted in human friendly way. Try to enter the date in your locale format. Or, to test, use =TODAY()-300 as start date and =TODAY() as end date.