Link to home
Start Free TrialLog in
Avatar of Flora Edwards
Flora EdwardsFlag for Sweden

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
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Rgonzo1971
Rgonzo1971
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Flora Edwards
Flora Edwards
Flag of Sweden image

ASKER

Thanks Ryan and Rgonzo.

both works fine.  i am just curious on the IFERROR used by Rgonzo.    why the IFERROR used here. what purpose does it serve?
Avatar of Flora Edwards
Flora Edwards
Flag of Sweden image

ASKER

Thank very much.
Avatar of Flora Edwards
Flora Edwards
Flag of Sweden image

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