Calculate how many times member A visit the cafe
Closed
jeff
-
26 Apr 2018 à 09:00
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 26 Apr 2018 à 11:46
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 26 Apr 2018 à 11:46
Related:
- Calculate how many times member A visit the cafe
- Formula to calculate vat in excel - Guide
- Internet cafe simulator 2 download - Download - Simulation
- You have guessed too many times ✓ - WhatsApp Forum
- How to calculate vat inclusive - Excel Forum
- Hp desktop red light flashing 4 times - Hardware Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
26 Apr 2018 à 11:46
26 Apr 2018 à 11:46
Hi Jeff,
Not sure how you want the end result to look like, but the following formula will count the number of times your table of dates, contains dates higher then a given data:
=COUNTIF($A$1:$A1,">="&$E$1)
Where A1:A6 is the table of dates and E1 is the specified date (or replace it with an actual date instead of cell reference). In this example place the formula in B1 and drag it down.
To color the cell, use conditional formatting. When you want to color the cell red when the above formula is placed in column B and gives a result of 5, then:
- Select column B.
- Go to conditional formatting, found under the Start ribbon and select add rule.
- Choose to use a formula: =$B1=5, choose your Format.
- Hit OK when done.
Best regards,
Trowa
Not sure how you want the end result to look like, but the following formula will count the number of times your table of dates, contains dates higher then a given data:
=COUNTIF($A$1:$A1,">="&$E$1)
Where A1:A6 is the table of dates and E1 is the specified date (or replace it with an actual date instead of cell reference). In this example place the formula in B1 and drag it down.
To color the cell, use conditional formatting. When you want to color the cell red when the above formula is placed in column B and gives a result of 5, then:
- Select column B.
- Go to conditional formatting, found under the Start ribbon and select add rule.
- Choose to use a formula: =$B1=5, choose your Format.
- Hit OK when done.
Best regards,
Trowa
