Counting no. of days.

[roberte42]

Hi, my spreadsheet consists of rows of data commencing with the date in the first column. My first entry is on the 1st Jan 2023 for example. My next entry is on the 15th Jan. I want to know the number of days between them and display this somewhere on the sheet. I can do this using the DAYS formula. However on my next entry on 23rd, and on further entries I now wish for the number of days to be automatically updated without manually changing the range. Is this possible? Many thanks

 

[etaf]

IF these date are always entered in order - Latest LAST
then you can use
=MAX(A:A)-A2
Or if you want to use days()
=DAYS(MAX(A:A),A2)

Book6
	A	B	C	D
1
2	1/1/23		22	22
3	1/15/23
4	1/23/23
5
Sheet1

Cell Formulas
Range	Formula
C2	C2	=MAX(A:A)-A2
D2	D2	=DAYS(MAX(A:A),A2)

 

[roberte42]

IF these date are always entered in order - Latest LAST
then you can use
=MAX(A:A)-A2
Or if you want to use days()
=DAYS(MAX(A:A),A2)

Book6
	A	B	C	D
1
2	1/1/23		22	22
3	1/15/23
4	1/23/23
5
Sheet1

Cell Formulas
Range	Formula
C2	C2	=MAX(A:A)-A2
D2	D2	=DAYS(MAX(A:A),A2)

IF these date are always entered in order - Latest LAST
then you can use
=MAX(A:A)-A2
Or if you want to use days()
=DAYS(MAX(A:A),A2)

Book6
	A	B	C	D
1
2	1/1/23		22	22
3	1/15/23
4	1/23/23
5
Sheet1

Cell Formulas
Range	Formula
C2	C2	=MAX(A:A)-A2
D2	D2	=DAYS(MAX(A:A),A2)

 

[roberte42]

Many thanks, you’re a star!! Robert

 

[etaf]

you are welcome