Getting Value error on the formula helped by Rgonzo1971

I had this question after viewing Formula to add values based on the date range..

please see attached. the formula now gives error. if the date range is not in complete quarter.
Who is Participating?
Like Bill said

you are mixing dates with format dd/mm/yy and format mm/dd/yy the formula can only adjust to one of them
because if the date 01/01/01 it cannot now which one it is
FloraAuthor Commented:
my dates are always  DD/MM/YY
FloraAuthor Commented:
Thanks very much.

i remembered.  my dates were not correct. it is now fixed.  thanks for pointing me to correct direction..

all of your formulas are flawless
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.