Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Counting non-expired dates Counting non-expired dates
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 10-23-2015, 08:44 AM
shg shg is offline Counting non-expired dates Windows 7 64bit Counting non-expired dates Office 2010 32bit
Advanced Beginner
  
Join Date: Oct 2015
Posts: 55
shg is on a distinguished road
Default
You're welcome.



Dates are just numbers, so ...

=COUNT(A1:A107)
Reply With Quote
  #2  
Old 10-23-2015, 12:23 PM
bbutl027 bbutl027 is offline Counting non-expired dates Windows 8 Counting non-expired dates Office 2013
Novice
Counting non-expired dates 		 
Join Date: Mar 2015
Posts: 17
bbutl027 is on a distinguished road
Default
Tried that it does not work for whatever the reason. I need to be able to count the cells that have dates in them.
Reply With Quote
  #3  
Old 10-23-2015, 01:43 PM
shg shg is offline Counting non-expired dates Windows 7 64bit Counting non-expired dates Office 2010 32bit
Advanced Beginner
  
Join Date: Oct 2015
Posts: 55
shg is on a distinguished road
Default
Post an example that shows it not working.
Reply With Quote
  #4  
Old 10-26-2015, 06:37 PM
bbutl027 bbutl027 is offline Counting non-expired dates Windows 10 Counting non-expired dates Office 2016
Novice
Counting non-expired dates 		 
Join Date: Mar 2015
Posts: 17
bbutl027 is on a distinguished road
Default
Correction, I still had the if in the equation. Thank you
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting unique visitors by ward, counting monthly visits by status, editing existing workbook JaxV Excel 9 11-14-2014 12:25 AM
Counting non-expired dates one trial version expired. Can I .... t-4-2 Office 3 12-06-2011 10:33 PM
Expired Certificate message in Outlook 2007 tupham Outlook 0 11-15-2011 02:50 PM
Counting non-expired dates OWA Certificate Expired Issue ama Outlook 2 03-18-2011 02:11 PM
Counting non-expired dates how to display expired date in red (access) iffy Office 5 01-16-2011 06:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:39 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft