Hi! Using LibreOffice v6.0.7.3 on Linux Mint v19.2 Mate
I have a spreadsheeet in Calc which records data of reactions to a particular performer. It is in the form: It has Columns A - G. A - Name, fformatted as Text (records thre name of the persons doing the reaction) B - No, formatted number general (records number of times this reactors has reacted to the performer) C - First, formatted DD/MM/YY (records the first date the reactor reaacted to this performer) D - Last, formatted DD/MM.YY (records last date reactor reacted to this performer) E - Days, formatted =NOW()-D3 (records number of days since last reaction) F - Weeks, formatted =E3/7 (records number of weeks since last reaction) G - Months, formatted =F3/4 (records number of months since last reaction. reaction) Is there a formula that I can enter in Column B which will increase incrementally increase the figure by 1, please? Regards from New Zealand on a very warm summer evening. David -- Zed "To use the term blind faith, is to use an adjective needlessly." Julian Ruck -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
