Hi Everyone,

I need to create an 'IF' function that nests four EOMONTH functions.

The following throws an error:

=IF(D12="1st month goes here",EOMONTH(D7,2),if(D12="2nd month goes here",EOMONTH(D7,3),if(D12="3rd month goes here",EOMONTH(D7,5)))

EOMONTH will increase the date in the resultant cell accordingly.

Thanks in advance for your help.