PC Review


Reply
Thread Tools Rating: Thread Rating: 1 votes, 1.00 average.

Can anyone calculate age next birthday from date field?

 
 
=?Utf-8?B?U2hlaWxh?=
Guest
Posts: n/a
 
      26th Feb 2006
I am having great difficulty in creating a formula which will show the age
next birthday. Has anyone achieved this?
 
Reply With Quote
 
 
 
 
=?Utf-8?B?R2FyeScncyBTdHVkZW50?=
Guest
Posts: n/a
 
      26th Feb 2006
Your age on your next birthday is always one more than you age today (even if
today is your birthdate):

put your birthday in A1 and then:


=DATEDIF(A1,TODAY(),"y")+1
is what you want.
--
Gary's Student


"Sheila" wrote:

> I am having great difficulty in creating a formula which will show the age
> next birthday. Has anyone achieved this?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Birthday field date and time format New Vista user Windows Vista Mail 1 7th Apr 2008 04:19 AM
How to clear birthday events in the calendar without deleting birthday field data in the contacts? hoangvan.hn.vn@gmail.com Microsoft Outlook Interoperability 4 19th Jan 2008 01:43 AM
Calculate date - 1st of the month following 65th birthday - EXCEL =?Utf-8?B?Sm9hbg==?= Microsoft Excel Misc 4 23rd Mar 2007 05:14 PM
Compare access db birthday date field with date CZ Microsoft ASP .NET 1 23rd Sep 2005 05:19 AM
Calculate age / age next birthday from date of birth without using DateDiff solution Adrian Microsoft C# .NET 7 21st Sep 2004 03:46 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:21 PM.