View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Instead of using ATP functions, you can use the built-in DATE() function
to do the same thing. For instance, instead of

=EOMONTH(A1,1)

you can use

=DATE(YEAR(A1),MONTH(A1)+2,0)

since the 0th day of the month is always the last day of the previous
month.

In article ,
"Ronni T. Vasquez M." wrote:

Can anyone of you help me with this?