Forum Discussion
Count an Excel Cell with a Date
Hello, I have a sheet that has a list of 182 people that can buy a permit. I only want 10 active permits at any given time, so I want to set a counter at the top of the spreadsheet that shows ho...
- I tried that one and it isn't working. I also made sure to format the H column as short date. Should I maybe use another format? Thanks for helping!
Make sure that you format the cell with the formula as General.
In the example below, there are 4 dates in the future, so there are 10-4 = 6 available.
HansVogelaar Okay, I had the cell with the formula (I2) formatted as Date. Changed it to General. I left the H column formatted as date, but it's still not counting properly. Any other thoughts?
