Avatar of Flora Edwards
Flora Edwards
Flag 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
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Flora Edwards

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Ryan Chong

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Rgonzo1971

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Flora Edwards

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?
Flora Edwards

ASKER
Thank very much.
Flora Edwards

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
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23