Forum Discussion
Need help on excel
Hi All, Need help if any can. I have a formula, I need to adjust the formula with criteria if in cell F6 "AR" so result of1st date of an array must come with 1st day of the left side dated m...
Hi TariqRaza
You can use the Row() function to restrict the desired result only for the first date. The below formula may help you to achieve your requirements.
=IF(ROW(B9)>9,EOMONTH(B9,0),IF($F$6="AR",(DATE(YEAR(B9),MONTH(B9),1)),EOMONTH(B9,0)))
A sample working file is also attached for more understanding.
Please let me know if it works for you
Note: In case your data starts from another line, you will have to slightly modify the formula.
Thanks
Tauqeer