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.
Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
especially How to get the Best Results at Chandoo.org = There are some challenges to modify Your posted snapshot.