> > >>> I see. In that long discussion, there were 2 solutions in just one > >>> line > >>> (one formula) that don't depend on the SET DATE. This is why I asked. > >>> I > >>> thought you found some errors. > >> > >>BTW: The second method (Jim Booth mentioned one) was: > >> > >>? gomonth(date()-day(date())+1,1)-1 > > > >Yours or mine? :) Mine doesn't have the question mark... :) > > > >Vlad > > I haven't been around for a while...how about: > > ? (date()+32) - day(date()+32) > > Bill > > P.S. I haven't looked further down the thread...maybe this has already > been brought up... Hi Bill, This is the most excellent method I have ever seen! Good ideas should be appriciated!!! Regards, Biju