Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Date difference

Hi I need to add he inputs from today and less than 30 days. the best formula I go too is =SUMIF(A4:A11;">TODAY()-30";B4:B11) 1 Oct 2019 2 10 10 Oct 2019 5 15 Oct 2019 6 01 Nov 2019 7 14 Nov 2019 3 15 Nov 2019 4

Date difference

Hi I need to add he inputs from today and less than 30 days. the best formula I go too is =SUMIF(A4:A11;">TODAY()-30";B4:B11) 1 Oct 2019 2 10 10 Oct 2019 5 15 Oct 2019 6 01 Nov 2019 7 14 Nov 2019 3 15 Nov 2019 4

Date difference

Hi I need to add he inputs from today and less than 30 days. the best formula I go too is

=SUMIF(A4:A11;">TODAY()-30";B4:B11)
 1 Oct 2019  2     10
10 Oct 2019 5
15 Oct 2019 6
01 Nov 2019 7
14 Nov 2019 3
15 Nov 2019 4

4