The Code Cage - Microsoft Office help Free Microsoft Office Help for all Applications!  

To stop seeing these ads and get other benefits check This page!

Go Back   The Code Cage Forums > Newsgroups - Microsoft Topics > Newsgroup - Excel Forum > Worksheet Functions
Reload this Page [SOLVED]: Match date to today
Register Code Uploads/
Downloads 		FAQ Members List Calendar Search Today's Posts Mark Forums Read


Worksheet Functions Post questions in this forum if they are related to using Microsoft Excel Worksheet Functions, e.g Forumale or built in functionality etc.

Hey there!

It looks like you're enjoying but haven't created an account yet. Why not take a minute to register for your own free account now? As a member you get free access to all of our forums and posts plus the ability to post your own messages, communicate directly with other members and much more. Register now!

Already a member? Login at the top of this page to stop seeing this message.


Closed Thread
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 5th November 2009, 12:33 PM
Derek M
Newsgroup Contributor


My Top Tip Count:

 
Posts: n/a
Default [SOLVED]: Match date to today
------ Register to get rid of these "In Post" ads! ------


Hi All

need to match dates in a column of data to todays date, i.e.

3/11/09
4/11/09
5/11/09
5/11/09

If today is 5/11/09 then the cell would return the value 2, i cant figure
out the sum

Thanks for any help in advance

Derek

Did you find this post helpful? Yes | No
The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!
  #2 (permalink)  
Old 5th November 2009, 12:36 PM
Jacob Skaria
Newsgroup Contributor


My Top Tip Count:

 
Posts: n/a
Default RE: Match date to today
------ Register to get rid of these "In Post" ads! ------


If the dates in ColA are in excel date format the below would work...

=COUNTIF(A:A,TODAY())

If this post helps click Yes
---------------
Jacob Skaria


"Derek M" wrote:

> Hi All
>
> need to match dates in a column of data to todays date, i.e.
>
> 3/11/09
> 4/11/09
> 5/11/09
> 5/11/09
>
> If today is 5/11/09 then the cell would return the value 2, i cant figure
> out the sum
>
> Thanks for any help in advance
>
> Derek

Did you find this post helpful? Yes | No
  #3 (permalink)  
Old 5th November 2009, 12:37 PM
Forum VIP
MS Office Version: MS Office 97
MS Office Skill Level: New to MS Office


My Top Tip Count: 0

 
Join Date: Apr 2009
Age: 53
Posts: 810
Thanks to others: 0
Thanked 5 Times in 5 Posts
Rep Power: 10
joel has a spectacular aura aboutjoel has a spectacular aura about
Default Re: Match date to today
------ Register to get rid of these "In Post" ads! ------


It would be a subtraction

=today()-A3

Did you find this post helpful? Yes | No
The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!
  #4 (permalink)  
Old 5th November 2009, 12:42 PM
Derek M
Newsgroup Contributor


My Top Tip Count:

 
Posts: n/a
Default RE: Match date to today
------ Register to get rid of these "In Post" ads! ------


I think you have helped me before, and it worked again, thank you so much,
you are a genuis

Derek

"Jacob Skaria" wrote:

> If the dates in ColA are in excel date format the below would work...
>
> =COUNTIF(A:A,TODAY())
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "Derek M" wrote:
>
> > Hi All
> >
> > need to match dates in a column of data to todays date, i.e.
> >
> > 3/11/09
> > 4/11/09
> > 5/11/09
> > 5/11/09
> >
> > If today is 5/11/09 then the cell would return the value 2, i cant figure
> > out the sum
> >
> > Thanks for any help in advance
> >
> > Derek

Did you find this post helpful? Yes | No
  #5 (permalink)  
Old 5th November 2009, 12:52 PM
Derek M
Newsgroup Contributor


My Top Tip Count:

 
Posts: n/a
Default RE: Match date to today
------ Register to get rid of these "In Post" ads! ------


Ooh just one other thing if i may, what if i also wanted to reference another
column to filter out just one word i.e. match the date to today, but also
check another column for the word "mymail" and bring just those results back
(count mymail under todays date)

Thanks again

Derek

"Derek M" wrote:

> I think you have helped me before, and it worked again, thank you so much,
> you are a genuis
>
> Derek
>
> "Jacob Skaria" wrote:
>
> > If the dates in ColA are in excel date format the below would work...
> >
> > =COUNTIF(A:A,TODAY())
> >
> > If this post helps click Yes
> > ---------------
> > Jacob Skaria
> >
> >
> > "Derek M" wrote:
> >
> > > Hi All
> > >
> > > need to match dates in a column of data to todays date, i.e.
> > >
> > > 3/11/09
> > > 4/11/09
> > > 5/11/09
> > > 5/11/09
> > >
> > > If today is 5/11/09 then the cell would return the value 2, i cant figure
> > > out the sum
> > >
> > > Thanks for any help in advance
> > >
> > > Derek

Did you find this post helpful? Yes | No
  #6 (permalink)  
Old 5th November 2009, 01:28 PM
Jacob Skaria
Newsgroup Contributor


My Top Tip Count:

 
Posts: n/a
Default RE: Match date to today
------ Register to get rid of these "In Post" ads! ------


When you have multiple criteria use SUMPRODUCT()

=SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2))
=SUMPRODUCT((A1:A10=TODAY())*(B1:B10="mymail"))

If you are using XL2007; check out help on COUNTIFS()

If this post helps click Yes
---------------
Jacob Skaria


"Derek M" wrote:

> Ooh just one other thing if i may, what if i also wanted to reference another
> column to filter out just one word i.e. match the date to today, but also
> check another column for the word "mymail" and bring just those results back
> (count mymail under todays date)
>
> Thanks again
>
> Derek
>
> "Derek M" wrote:
>
> > I think you have helped me before, and it worked again, thank you so much,
> > you are a genuis
> >
> > Derek
> >
> > "Jacob Skaria" wrote:
> >
> > > If the dates in ColA are in excel date format the below would work...
> > >
> > > =COUNTIF(A:A,TODAY())
> > >
> > > If this post helps click Yes
> > > ---------------
> > > Jacob Skaria
> > >
> > >
> > > "Derek M" wrote:
> > >
> > > > Hi All
> > > >
> > > > need to match dates in a column of data to todays date, i.e.
> > > >
> > > > 3/11/09
> > > > 4/11/09
> > > > 5/11/09
> > > > 5/11/09
> > > >
> > > > If today is 5/11/09 then the cell would return the value 2, i cant figure
> > > > out the sum
> > > >
> > > > Thanks for any help in advance
> > > >
> > > > Derek

Did you find this post helpful? Yes | No
The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!
  #7 (permalink)  
Old 5th November 2009, 01:28 PM
Derek M
Newsgroup Contributor


My Top Tip Count:

 
Posts: n/a
Default RE: Match date to today
------ Register to get rid of these "In Post" ads! ------


Thanks for your help again, i veru much appreciate it, i am learning all the
time too

"Derek M" wrote:

> Hi All
>
> need to match dates in a column of data to todays date, i.e.
>
> 3/11/09
> 4/11/09
> 5/11/09
> 5/11/09
>
> If today is 5/11/09 then the cell would return the value 2, i cant figure
> out the sum
>
> Thanks for any help in advance
>
> Derek

Did you find this post helpful? Yes | No
The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!
Closed Thread

Bookmarks

Tags
date, match, today

New topics in Worksheet Functions

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

The Code Cage Affilliates
xlDynamic, The Code Cage Hosting Services, Car GPS, Create your own applications even with a database, Anti Spyware and much more


To stop seeing these ads and get other benefits check This page!



All times are GMT +1. The time now is 12:33 PM.

The Code Cage - Microsoft Office Help - Microsoft Office Discussion - Archive - Privacy Policy - Terms of Service - Top

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2
No part of this board may be copied or reproduced either in part or full without the express permission of The Code Cage Team.
We are not associated with nor employed by Microsoft in any way, we simply provide resources!
All MS office icons are registered trademarks of the application the represent