Got something to say or just want fewer pesky ads? Join us... 😊

[Technology] Excel help with dates



METALMICKY

Well-known member
Jan 30, 2004
5,935
Bit of a numpty with Excel so hoping someone can help.

I have a pretty basic spreadsheet of clients and I'm conjunction with their personal details I have their DOB in one field let's say cell A1 and in A2 I have a basic formula that returns their current age.

What I need to do is to be able to perform a count of how many clients turned 19 in the financial years 2016/17, 2017/18 and 2018/19 to date

Any ideas please
 


Iggle Piggle

Well-known member
Sep 3, 2010
5,281
Someone will respond in greater detail I'm sure as its thw cornerstone of NSC but it will be something like =COUNTIF(*highlight range* >01/,01/16, <31/12/18)
 


Iggle Piggle

Well-known member
Sep 3, 2010
5,281
Almost but not quite - In my defence I was getting the kids ready for school.

=COUNTIFS(B2:B4,">01/01/2016",B2:B4,"<31/12/2018")

Where B2:B4 equals the range you want to count. The formula can go in any cell
 


hans kraay fan club

The voice of reason.
Helpful Moderator
Mar 16, 2005
61,094
Chandlers Ford
Bit of a numpty with Excel so hoping someone can help.

I have a pretty basic spreadsheet of clients and I'm conjunction with their personal details I have their DOB in one field let's say cell A1 and in A2 I have a basic formula that returns their current age.

What I need to do is to be able to perform a count of how many clients turned 19 in the financial years 2016/17, 2017/18 and 2018/19 to date

Any ideas please

=GDPRFAIL(3xmnthJail + >£Fine)
 








Uter

Well-known member
Aug 5, 2008
1,474
The land of chocolate
Something like this maybe? Excel even seems smart enough to cope with leap years without any special programming.

ExcelProb1.PNG

ExcelProb2.PNG
 



Paying the bills

Latest Discussions

Paying the bills

Paying the bills

Paying the bills

Albion and Premier League latest from Sky Sports


Top
Link Here