Data entry and virtual assisatant for $50-Programmier-Enthusiast

Data entry and virtual assisatant for $50

Frank Fischer June 06,2023

How does Excel allow for leap years?

complete years, I just need the first part of the formula).

By the way, I am not familiar with DATEDIF and it does not appear to be on

my list of available formuale in my version of Excle (Office Xp) (yet it

still works).

Alos, whilst I know what TODAY() is and I assume that, in your example, the

date for comaprison is in cell A1, what would be in cell A2?

Many thanks again.

Neil

"Peo Sjoblom" wrote:

=DATEDIF(A1,TODAY(),"y")&" year(s) and "&DATEDIF(A1,A2,"yd")&" day(S)"

Regards,

Peo Sjoblom

"Neil" wrote in message

...

I am trying to calculate the number of years in a person's age by reference

to date of birth and today's date.

When I put DoB as 12/5/2003 against today's date of 11/05/2006, it comes

back as 3 whole years, when in fact it is 2 and 364 days. Excel seems to

ignoring the leap year in 2004. If I use 13/05/2003 as DoB, it comes back

correctly as just 2 years.

How can I correct fro this via a simpel formula?

Many thanks in advance for all help received?

Neil

Thanks Peo, this basically helps me to solve it (as I only want the number ofcomplete years, I just need the first part of the formula).By the way, I am not familiar with DATEDIF and it does not appear to be onmy list of available formuale in my version of Excle (Office Xp) (yet itstill works).Alos, whilst I know what TODAY() is and I assume that, in your example, thedate for comaprison is in cell A1, what would be in cell A2?Many thanks again.Neil"Peo Sjoblom" wrote: Reply With Quote

Uganda Office stationery Import data with price, buyer, supplier, HSN code

How data of Uganda Office stationery imports can help ?

Data of Uganda Office stationery imports contains strategic information and is very useful for importers and exporters who want to expand global trade, improve supply chain of Office stationery , find economical vendors, new buyers and fast growing markets.