Apple Intelligence is now available on iPhone, iPad, and Mac!
In numbers wil ik met AANTALLEN.ALS kolommen laten meetellen waarin een datum staat die later is dan een bepaalde datum. Die bepaalde datum wil ik in een cel in de spreadsheet zetten, zodat die makkelijk te wijzigen is.
iMac (M1, 2021)
Hi jjbveld,
Apply COUNTIF to dates
In numbers I want to use COUNTIF to count columns that contain a date that is later than a certain date. I want to put that specific date in a cell in the spreadsheet, so that it can be easily changed.
The table has a Header Row and a Footer Row.
Formula in B8 is COUNTIF(B,">"&B$1)
De tabel heeft een koptekstrij en een voettekstrij.
Formule in B8 is AANTAL.ALS(B;">"&B$1)
Regards,
Ian.
Hello yellow box!
I also tried this formula and I would like to add a question.
I made an extra table where I would like only the selected dates to be highlighted. Is it possible to get table 2 to update if I insert rows in table 1?
In table 2 the data is copied and filtered
Hi Dubbia,
Sorry for the late reply. It took me a while to work through this.
One table with an extra column and a filter (Text is Show).
Formula in B2 is IF(A2="","Show",IF(A2>A$1,"Show",""))
The filter will show rows where the date is > A$1 or a cell in A is blank (for you to enter another date).
Filter on:
Regards,
Ian.
Thank you, Ian 👍
AANTALLEN.ALS toepassen op datums
