View Single Post
  #3   Report Post  
Ronni T. Vasquez M.
 
Posts: n/a
Default

Hi,

Thanks a lot for your help!!!

You were right!!!

It worked!!!

Regards,

--
Ronni T. Vasquez M.

"JE McGimpsey" wrote in message
...
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?