View Single Post
  #3   Report Post  
Ron Coderre
 
Posts: n/a
Default

I can think of 2 ways to go with this, depending on how you want the first of
the month treated:
=EOMONTH($A$1-1,3)+1
OR
=EOMONTH($A$1,3)+1

Note: Per Excel Help:If this function is not available, and returns the
#NAME? error, install and load the Analysis ToolPak add-in.


Does that help?

--
Regards,
Ron