Need help on excel

New Contributor

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 month and rest should be the end of the month

 

(Note if cell F6 is with AR Only 1st date should come with 1st date of the month rest should be the end of the month), if not AR all should come with the end of the month date.

 

i am really thankful

 

Regads

 

Tariq

 

TariqRaza_1-1637168836094.png

 

 

0 Replies