Flora Edwards

asked on

# Formula Date modification by Rongzo1971

I had this question after viewing modification of formula as i get another problem..

i have another challenge where my database dates are stored in a weird way. please see attached. the formula returns zero

thanks for your help as usual. much appreciated.

EE3.xlsx

i have another challenge where my database dates are stored in a weird way. please see attached. the formula returns zero

thanks for your help as usual. much appreciated.

EE3.xlsx

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thank very much.

ASKER

dear Ryan and Rgonzo. i have posted a follow up question with sample data which i could not solve by myself. it looks very complicated to add more condition to the sumproduct.

i really appreciate your help. here is my question posted https://www.experts-exchange.com/questions/29068162/Formula-modification-help-needed-Rgonzo1971-Ryan-Chong-earlier-solution.html

i really appreciate your help. here is my question posted https://www.experts-exchange.com/questions/29068162/Formula-modification-help-needed-Rgonzo1971-Ryan-Chong-earlier-solution.html

ASKER

both works fine. i am just curious on the IFERROR used by Rgonzo. why the IFERROR used here. what purpose does it serve?