Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

End of month date

0 views
Skip to first unread message

Engineer@pnb.retired_1987 Don Schmidt

unread,
Sep 21, 2009, 8:10:45 AM9/21/09
to
I use Lotus 1-2-3 v9.8 and have a need to have the most current end of last
month automatically displayed. Can it be done? How?

For instance to show the last date of August until October 1st which then
will show the last date of September until November 1st and so on.

The goal is to have all month to review and print out a report of last
months results.

Many thanks,


--
Don
Vancouver, USA


Ron Avanzino

unread,
Sep 24, 2009, 2:55:14 PM9/24/09
to
If a date is in cell A5, put in cell B5:

@DATE(@YEAR(A5),@MONTH(A5),1)-1

"Don Schmidt" <Don Engi...@PNB.Retired_1987> wrote in message
news:9v2dnfm5Vavb8CrX...@posted.palinacquisition...

Engineer@pnb.retired_1987 Don Schmidt

unread,
Sep 24, 2009, 11:52:41 PM9/24/09
to
Perfect! Many thanks Ron.

--
Don
Vancouver, USA


"Ron Avanzino" <rava...@yahoo.com> wrote in message
news:uObPkiUP...@TK2MSFTNGP05.phx.gbl...

0 new messages