• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Formula required for Date Pickup from table


New Member
Dear All,

I am trying to pick the date from the existing table where if the date in column D falls above c6 and below eomonth(C6,0)+1 i.e. 1st Oct'20, it will pick 28th Sep'20 i.e. D1+1 else it will take first day of next month from C6.



Excel Ninja
Please, reread Forum Rules
especially How to get the Best Results at Chandoo.org
= There are some challenges to modify Your posted snapshot.