Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: #VALUE! Riny_van_Eekelen Thank you my friend for sharing a moment of your time for me...this worked nicely. I will study what you did and learn from it...again many thanks to you for your kindness. Re: #VALUE!Thank you for the help...I checked every cell format to make sure it was a date or a number...still nothing...but thank you...#VALUE! I can't find why I get the value error in this formula I put in...it should tell me how many days or just show open...its probably something simple but I can't see it Solved