[Solved] Sum of today's transactions

Discuss the spreadsheet application
Post Reply
dentopolis
Posts: 19
Joined: Mon Sep 23, 2013 2:44 pm

[Solved] Sum of today's transactions

Post by dentopolis »

mam zapisane daty transakcji w formacie:
2021-07-21 14:48
2021-07-21 14:20
2021-07-21 13:53

chciałbym podsumować kwotę jeżeli data jest większa niż dzisiaj czyli >DZIŚ(), tylko jak to powinno wyglądać gdy komórka zawiera jednocześnie datę i czas?
 Edit: This is an English-speaking forum. If you post again in Polish, the topic to be locked.
I suspect Polish function DZIŚ() is English function TODAY().
-- MrProgrammer, forum moderator 
Last edited by MrProgrammer on Fri Jul 30, 2021 1:44 am, edited 1 time in total.
Reason: Tagged ✓ [Solved]
LibreOffice 7.4
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: total of today's transactions

Post by RoryOF »

This is an English language Forum. Below is an automatic translation of the message above

I have saved transaction dates in the format:
2021-07-21 14:48
2021-07-21 14:20
2021-07-21 13:53

I would like to sum up the amount if the date is greater than today i.e. >DAY(), but how should it look when the cell contains both date and time?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: suma dzisiejszych transakcji

Post by FJCC »

The attached file shows two solutions in cells C2 and C3. The difference is whether the sum should include today's amount.
Attachments
GreaterThanToday.ods
(10.89 KiB) Downloaded 88 times
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Post Reply