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-22-2015, 07:04 AM
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 Counting non-expired dates
I trying to figure out the best way to go about this situation. I have multiple certification dates that must be tracked. At the bottom of each column must count up all the non-expired dates. The expiration falls on the anniversary date of the date entered.
Attached Files
File Type: xlsx Book1.xlsx (16.4 KB, 9 views)
Reply With Quote
  #2  
Old 10-22-2015, 09:07 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 mean like ...

=COUNTIF(A1:A107, ">" & EDATE(TODAY(), -12))
Reply With Quote
  #3  
Old 10-22-2015, 01:54 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
That worked like a champ thank you. But one last thing what would the formula be for counting cells with dates in them?
Reply With Quote
  #4  
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
  #5  
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
  #6  
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
  #7  
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 01:38 PM.

Contact Us - Privacy Statement - Top

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