Counting Birthdays

Using Windows XP and Office 2007

Other calendar programs I have used in the past allow me to "count" the 
number of occurrences of an event like a birthday.  I could set the 
recurrence to every year on that specific date and it would display as 
"Susie's 7th birthday."

Although I can set the recurrence of an event like a birthday to every year 
on a specific date in  Outlook 2007, I don't see a way to get a "count" of 
that event.  Am I just missing it, or is it just not an available option? 


0
BK
12/31/2009 3:42:34 PM
outlook 87535 articles. 11 followers. Follow

2 Replies
704 Views

Similar Articles

[PageSpeed] 50

It's not a option. It is possible to show the age on the contact form but 
not in the subject.
See http://www.outlook-tips.net/code/age_form.htm

If you want the age in the subject line, you need to make individual 
appointments -
http://www.outlook-tips.net/howto/countdown.htm

-- 
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:dailytips-subscribe-request@lists.outlooktips.net

EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM

Poll: What version of Outlook do you use?
http://forums.slipstick.com/showthread.php?t=27072


"BK" <nospam@nospam.com> wrote in message 
news:e4x4g$iiKHA.2780@TK2MSFTNGP05.phx.gbl...
> Using Windows XP and Office 2007
>
> Other calendar programs I have used in the past allow me to "count" the 
> number of occurrences of an event like a birthday.  I could set the 
> recurrence to every year on that specific date and it would display as 
> "Susie's 7th birthday."
>
> Although I can set the recurrence of an event like a birthday to every 
> year on a specific date in  Outlook 2007, I don't see a way to get a 
> "count" of that event.  Am I just missing it, or is it just not an 
> available option?
> 
0
Diane
12/31/2009 4:47:25 PM
Thanks, Diane.  I'll see if either of these options fit.


"Diane Poremsky [MVP]" <outlookmvp@msn.com> wrote in message 
news:B7D8668F-9593-40CC-8199-6915CEB80F17@microsoft.com...
> It's not a option. It is possible to show the age on the contact form but 
> not in the subject.
> See http://www.outlook-tips.net/code/age_form.htm
>
> If you want the age in the subject line, you need to make individual 
> appointments -
> http://www.outlook-tips.net/howto/countdown.htm
>
> -- 
> Diane Poremsky [MVP - Outlook]
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com/
>
> Outlook Tips by email:
> mailto:dailytips-subscribe-request@lists.outlooktips.net
>
> EMO - a weekly newsletter about Outlook and Exchange:
> mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>
> Poll: What version of Outlook do you use?
> http://forums.slipstick.com/showthread.php?t=27072
>
>
> "BK" <nospam@nospam.com> wrote in message 
> news:e4x4g$iiKHA.2780@TK2MSFTNGP05.phx.gbl...
>> Using Windows XP and Office 2007
>>
>> Other calendar programs I have used in the past allow me to "count" the 
>> number of occurrences of an event like a birthday.  I could set the 
>> recurrence to every year on that specific date and it would display as 
>> "Susie's 7th birthday."
>>
>> Although I can set the recurrence of an event like a birthday to every 
>> year on a specific date in  Outlook 2007, I don't see a way to get a 
>> "count" of that event.  Am I just missing it, or is it just not an 
>> available option?
>> 


0
BK
12/31/2009 7:45:27 PM
Reply:

Similar Artilces:

Counting number of occurrences based on 2 ranges
Hi Have two ranges a1:a55 and e1:e55 and want to count the number of occurrences where cell a = "Yes" and cell e = 27-11-03. Cant use countif because only counts the occurrences based on one range. Any help appreciated Regards Dynamo Hi =SUMPRODUCT((a1:a55="Yes")*(e1:e55=DATE(2003,11,27))) or =SUMPRODUCT((a1:a55="Yes")*(e1:e55=MyDate)) where MyDate is reference to cell with date -- (When sending e-mail, use address arvil@tarkon.ee) Arvi Laanemets "Dynamo" <Dynamo_member@newsguy.com> wrote in message news:boa2bv01n3s@drn.newsguy.com... >...

highlighting & counting each cell
i want to highlight a list of cells (with people's names) and have it count how many cells i selected. is there a way to do this also, how do i do this with numeric cells and have it give me the total thanks for the help! Sneilan, In the Status Bar (far bottom of window), you'll see SUM=nn if you select more that one cell. Right click that, select COUNT. It should now give you COUNT=nn -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Sneilan" <anonymous@discussions.microsoft.com> wrote in message news:EBFE8...

Inventory count
What should buy to count and adjust the inventory. I need some thing I can go each departmen and count merchantdise and adjust it. Gill, How about an inexpensive, wireless laptop? Assuming you have wireless in the store. If not, wireless access points are cheap. Just make it secure with WPA or WPA2. Install RMS on it, add a bar code scanner, put it on a rolling cart and go for it! -- * Get Secure! - www.microsoft.com/security You must be using Outlook Express or some other type of newsgroup reader to see and download the file attachment. If you are not using a reader, follow the...

Count number of people
We will be hosting a large fund raiser. I need to know the number of people attending. Here's my problem................ Some people come as couples, and some as singles. For example, I have listed Jim & Susan Brown. But in the same list I have Bill Smith, and Ann Johnson. If ALL of these people RSVP with a yes, it represents 4 attendees. I think the key to determining if it is 1 or 2 people attending is the ampersand "&". If I have an ampersand, it should count as two; no ampersand, it is 1. How can I use a function or functions to make this dist...

count the number of caracters in a cell #2
How can I count the number of caracters including spaces in a microsoft excel worksheet Try... =LEN(A2) Hope this helps! In article <04929C51-79FA-4056-A3BF-6CFC3432689A@microsoft.com>, Jan <Jan@discussions.microsoft.com> wrote: > How can I count the number of caracters including spaces in a microsoft excel > worksheet Subject says cell, body says worksheet. I'll tackle the cell issue: for a cell you can use the formula = LEN(A1) where A1 is the address of the cell with the text you need to find the number of characters for. "Jan" wrote: > How ...

How to count same numbers in a coluum #3
Thanks Dave for the PivotTable links. Fran -- FPA186 ----------------------------------------------------------------------- FPA1869's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1470 View this thread: http://www.excelforum.com/showthread.php?threadid=26336 ...

HELP! Simple (?) Data Counting
I am having a LOT of trouble with what seems to me should be a fairly simple function. I am setting up a sort of database for our sales department. It contains 16 criteria headings. At the end of each day, the manager will go in and enter the information for each sale (1 sale will occupy one row in the list). Most of the fields have pull-down menus for consistency of information. I consider this the raw data. Next, I have 7 worksheets, each dedicated to an individual salesman. These sheets are identical in format. Each individual product is listed down the left-hand side (there are 49 di...

Count how many times and sort ?
I have a table TReport which have a field called vcHeader. In vcHeader is mention 3 different city names and some other text. I now want to count how many time each city is in the table and sort by how many times they are mention. I know how to search for one city, like this - SELECT count(*) AS Cities FROM TReport WHERE vcHeader Like '*NameOfCity*'; and a result like this - Cities HowManyTimes A 99 B 66 C 33 But I'm all out of ideas, how to do it. SELECT city, COUNT(*) FROM treport WHERE vcHeader LIKE "*NameOfCity*" GROUP BY city ODER BY city The WHERE clause c...

How to count the members of a distribution list?
Hello, Anyone know of a way please to count the number of members of each distribution list in a user's own Contacts folder, without writing code? Thanks, - Alan. open and count them. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: dailytips-subscribe-request@lists.outlooktips.net Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Subscribe to Excha...

Re: Counting Occurrences with 2 columns
Suppose your data is in Sheet1 in A2:C6 > Red 4 Read > Blue 5 Not Read > Green 6 Read > Yellow 2 Read > Red 3 Not Read Try this set-up in a new sheet, say Sheet2 ------------- List down in A2:A5 the names: Red, Blue, Green, Yellow Put across in B2:C2 the phrases: Read, Not Read Put in B2: =SUMPRODUCT((Sheet1!$A$2:$A$6=$A2)*(Sheet1!$C$2:$C$6=B$1)*(Sheet1!$B$2:$B$6) ) Copy B2 across to C2, then copy down to C5 [Note that the ranges used in SUMPRODUCT have to be similar and you can't use entire columns e.g.: A:A, B:B, C:C]...

Counting Data
I have a list of data that can have the same value. How can i count the number of similarities and get it to display the result in the next row. For example:- BOTTLE_CHK-2707 BOTTLE_CHK-2707 CALSOLUT-0563 DEF-ESTATE-2088 DEF-ESTATE-2088 EDEN_DC-2682 ELS_LTD-2450 ELS_LTD-2450 ESSEXCRP ESSEXCRP ESSEXCRP HARDING_EN-2558 Thanks in advance =SUMPRODUCT((A1:A20<>"")/COUNTIF(A1:A20,A1:A20&"")) change the A20 to wherever your data ends. ...

Counting Different Names in A Column... Formula?
Just wanted to know if there is a Formula that can count DIFFEREN names in a Column? eg. There may be more than 1 same name, but I dont want it counted twice: James Edward Max John David James James Lisa Total should = 6 (Since James is 1 person) Is there a formula to solve this type of count? Thanks for any hel on this. -- Mh ----------------------------------------------------------------------- Mhz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3598 View this thread: http://www.excelforum.com/showthread.php?threadid=57109 Try this For a list of...

Need count of updates after UPDATE query
Is there any way to get the count of updates after running this? strSQL = "UPDATE ..." currentproject.connection.execute strSQL On Fri, 15 Feb 2008 12:04:00 -0800, mscertified wrote: > Is there any way to get the count of updates after running this? > > strSQL = "UPDATE ..." > currentproject.connection.execute strSQL Look up the RecordAffected property in VBA help. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail ...

Counting 'up' rows instead of down
I have a series of rows that show W's (wins) and L's (Losses) from baseball tournaments. Example: W W L L W W W L W W L What formula can I use to count from the bottom up, counting only the most recent W's near the bottom, ending the count at the first L to show the most recent winning streak (in this case, it would show "2"). Thanks! Are you wanting a formula to be copied down, or a single formula? Copy-down style: In B2: =IF(A2="W",B1+1,0) Single formula: Start with above style, and we will then hide that column. Single out...

Counting Keystrokes in Excel
We are having some data entry done, does anybody know a way to determin the number of keystrokes in a worksheet range? Sure would appreciate the help. Thank -- jlan ----------------------------------------------------------------------- jlane's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1642 View this thread: http://www.excelforum.com/showthread.php?threadid=27793 Hi JLane, Excel, unlike Word, does not have an inbuilt character count feature. If the data entry comprises alphanumeric text without formulae, you could use an array formula: =SUM(L...

=Count([Category] if it is equal to 'Task ID'"), how do I fix thi
Hello, I have a report with the fields "Date","Catgory","Amount" and I have grouped it by "Date" by day. For each day I need to Count the indivudual categories. There are approximately 22 categories that the records are categorized by. So I figured that I would need to create 22 text box's each with their own variation of their category such as somthing along the lines of the below but I need your help. Please. How do I fix these? I will be placing these text boxes in the "Date Footer". Thanks. =Count([Category] if it i...

count amount of cells
Hi, How to count cells that contains formulas but only the ones tha returns a value? I thought I could use function "counta", but that function counts al cells, probably becouse all cells containing formulas. Any ideas? //Thoma -- Jonsso ----------------------------------------------------------------------- Jonsson's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=547 View this thread: http://www.excelforum.com/showthread.php?threadid=27661 Hi hope you don't think this is a silly question but what do the cells containing formulas return if n...

Stock count processing for serial tracked items
When processing stock counts for serial tracked items, GP defaults to '(not Set)'. Users believe this should default to 'Counted' or at leat a facility to mass update serial lines. This would be helpful to process stock take for items that have hundred serial numbers ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based News...

Count ticked check box
In my query I want to count the Yes/No in Worksheet, so where do I enter the 0 to find out how many are ticked!..Thanks for any help..Bob Count: DCount("Worksheet","qryWorksheetActive") Oops got it, New query with a Like'-1' and then have a count column...Thanks Bob "Bob V" <rjvance@ihug.co.nz> wrote in message news:e%23u$aKiqHHA.4268@TK2MSFTNGP03.phx.gbl... > > In my query I want to count the Yes/No in Worksheet, so where do I enter > the 0 to find out how many are ticked!..Thanks for any help..Bob > Count: DCount("Workshe...

How to use count for calls per hour
I am trying to create a pivot table and chart that will show me the # of calls per hour by day for a range of dates Aug 1 - Sept 19. My data looks like this where each line is the date and time of the call: How do I get a count of the # of the calls per hour by day? 8/1/08 12:48 AM 8/1/08 1:53 AM 8/1/08 2:36 AM 8/1/08 3:24 AM 8/1/08 3:37 AM 8/1/08 4:04 AM 8/1/08 4:44 AM 8/1/08 4:55 AM 8/1/08 4:58 AM 8/1/08 7:02 AM 8/1/08 7:28 AM 8/1/08 7:43 AM 8/1/08 7:47 AM 8/1/08 7:56 AM 8/1/08 7:58 AM 8/1/08 8:13 AM 8/1/08 8:33 AM 8/1/08 9:07 AM 8/1/08 10:28 AM 8/1/08 10:38 AM 8/1/08 10:44 AM 8/1/08 ...

Matching letters and then counting
OK Guys I have a problem that I have tried to solve but coming up with nothing. Below is a sample of the raw data that I have. It is a mixture of letters and numbers. Raw Data O O L0 L2 C I have to match these letters to corrosponding letters from a different data set: 1st Code 2nd Code X N,K,L0 S C U D M A R E C H,O,L2,B2 So the anser would be: X= 1 S= 1 U= 0 M= 0 R= 0 C= 3 Any help would be appreciated. Thanks, Sam. I think you need a formula for each code. Here ar two versions. for code x =SUMPRODUCT(--(A2:A6="n")+(A2:A6="...

Counting entries which match specified criterial
I have the below table and I would like to count how many "ANC" entries are ongoing. The first column range is called "anclist" with the second called "status2". Using the array formular below excel 2003 returns a count of too {=SUM((anclist="anc141")*(status2="ongoing"))} However when i use a wildcard as noted in the formular below, to expand the search the formular fails. {=SUM((anclist="anc*")*(status2="ongoing"))} Item status ANC141 ongoing ANC142 closed CNC001 closed ANC144 ongoing ANC141 o...

Count Formula 11-17-09
Hello, I'm having trouble posting, so please forgive me if you get this reuqest more than once. I have a form in Excel that has a check box in rows F8:F27. If you click on the box a check mark will appear. What formula do I use to count the number of boxes checked? -- Thanks, Annie Try this: =3DCOUNTIF(F8:F27,"<>") Hope this helps. Pete On Nov 17, 5:48=A0am, Annie <An...@discussions.microsoft.com> wrote: > Hello, > > I'm having trouble posting, so please forgive me if you get this reuqest > more than once. > >...

Counting codes
An example best illustrates my problem: I have a long column of product codes, like the following 01051110 01051190 01051900 01059100 01059900 01060010 01060020 01060030 01060090 02062200 02062900 02063000 02064100 02064900 03011000 03019100 03019200 03019300 As you can see products start 01 then go to 02 then 03. In practice this continues-04,05 etc until i come to 09, then it changes to 11, 12, 13,..19 then changes again to 21, 22, 23,..29. It does this until 91, 92,...99. I wish to count the number of 2-digit products and present them in a table. For example there are, in this example...

Zipcode range counting/filtering
Okay, I'll try to keep this fairly striaght forward, but let me explai the why before I explain the what... I am in charge of a marketing mailing project that covers all of Nort America. My company has broken NA up into 5 zones, using zipcodes a their guide... What I've been doing over the last few months i tracking everything I send by requests per item, requests by produc group, by total volume of requests per month. I am trying to tren everything I possibly can right now... What I want to add to this is breakdown how much of a months worth of mailings go to a particula zone... An...