Shorter, but not correct...

Further, EOMONTH, at least with the ATP, will be far slower than using
the built-in XL functions (and using 3 references rather than 2 will
slow it further).

Also,


=IF(D3,...

is equivalent to

=IF(D3=0,...

so if users "clear" a cell by hitting the space bar (something my
clients do all the time), the formula will return:

#VALUE!

Better:

=IF(LEN(TRIM(D3))=0,...

or in this case:

=IF(ISNUMBER(D3),...

etc.


In article ,
Shane Devenshire wrote:

If you want shorter then

=IF(D3,EOMONTH(D3,IF(EOMONTH(D3,2)+1-D390,2,5))+1,"Not yet")