| |||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Hello and welcome to CertForums.co.uk, here we host free active certification forums with links to the best free resources for Microsoft's MCSA MCSE MCDBA Cisco's CCNA CCDA and CCNP, and CompTIA's A+ Network+ i-NET+ and Security+ certifications in the UK. If you wish to post or use other advanced features you will need to register first. Registration is absolutely free and takes only a few minutes to complete so sign up today! If you have any problems with the registration process or your account login, please contact support |
|
|||||||
| Home | Forums | Community | Register | Search | Today's Posts | Mark Forums Read |
|
|
|
searching dates in excel!!! |
  |
|
|
Thread Tools | Display Modes |
|
#1
29-Apr-2008, 03:04 PM
|
|||||
|
|||||
|
searching dates in excel!!!
Hi All,
I had a request from a user at work, She's got a spreadsheet and would like to do the following "I want to calculate the number of entries between two dates so we can work out statistics by month" Basically what she wants is to enter two dates say 01/01/08 to 28/02/08 And excel to return the number of entries between those dates eg 01/01/08 - food1 05/02/08 - food2 31/03/08 - food3 24/02/08 - food4 With the criteria above it would return "3" I could use countif but don't know how to search between dates Any idea's / help would be gratefully accepted Thanks
|
|
|
|
#2
29-Apr-2008, 03:15 PM
|
|||||
|
|||||
|
=COUNTIF(A1:A4,">=1/1/2008")-COUNTIF(A1:A4,">28/2/2008")
Replace the range A1:A4 with the range you want. BosonMichael MCSE+I, MCSE: Security, MCDST, MCDBA, OCP, CCNP, CCDP, CNE, SCSA, Security+, Linux+, Server+, Network+, A+ Served proudly, US Army, 98C Intelligence Analyst, '89-'92
|
|
#3
29-Apr-2008, 03:43 PM
|
|||||
|
|||||
|
Thanks BosonMichael,
Worked a treat!! You're a star!!!! (what user said to me!!!, so fitting I pass on the compliment to the reason solver)!!! lol 
|
|
#4
29-Apr-2008, 03:52 PM
|
||||||
|
||||||
|
Quote:
 BosonMichael MCSE+I, MCSE: Security, MCDST, MCDBA, OCP, CCNP, CCDP, CNE, SCSA, Security+, Linux+, Server+, Network+, A+ Served proudly, US Army, 98C Intelligence Analyst, '89-'92
|
|
#5
29-Apr-2008, 04:03 PM
|
||||||
|
||||||
|
Quote:
 Me: You need to buy a couple of servers. Customer: Whats wrong with the servers I have? Me: Well, you dont have *any* servers just now. Customer: WTF! I thought I did!
|
|
#6
29-Apr-2008, 04:51 PM
|
||||||
|
||||||
|
Quote:
just kidding. BosonMichael MCSE+I, MCSE: Security, MCDST, MCDBA, OCP, CCNP, CCDP, CNE, SCSA, Security+, Linux+, Server+, Network+, A+ Served proudly, US Army, 98C Intelligence Analyst, '89-'92
|
|
#7
02-May-2008, 08:16 PM
|
|||||||||
|
|||||||||
|
Quote:
You must be a fortune teller Sparky, I had 4 more function requests from the same user. lucky knew the answer!!Quote:
|
Spread this thread:
|
|
|
|
||||||
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Exporting files from IBM mainframe to Excel - possible? | damo101 | Programming & Scripting | 4 | 31-Mar-2008 02:34 PM |
| Microsoft Finds Excel Security Flaw | zimbo | News | 0 | 22-Jan-2008 09:28 PM |
| Excel forumula | Nelix | Microsoft Office and Office Server | 2 | 19-Dec-2007 08:38 AM |
| Link outlook to excel | Rob1234 | Software | 4 | 27-Oct-2007 09:52 AM |
| Help with a function in Excel | asymvivastos | Software | 27 | 18-Oct-2007 08:15 PM |
All times are GMT. The time now is 09:41 PM.