Note: The other languages of the website are Google-translated. Back to English
Belépek  \/ 
x
or
x
Regisztráció  \/ 
x

or

Hogyan lehet gyorsan konvertálni a születési dátumot az Excelbe?

Például különféle születési dátumadatokat kap az Excel-ben, és ezeket a születési dátumokat meg kell alakítania, hogy megjelenítse a pontos életkori értéküket az Excelben. Hogyan szeretné kitalálni? Ez a cikk felsorol néhány tippet a születési dátum öregséggé alakításához az Excelben.

A. módszer:
Konvertálja a születési dátumot életkorra képletekkel

B módszer:
Könnyen konvertálhatja a születési dátumot életkorra anélkül, hogy emlékezne a képletekre


Konvertálja a születési dátumot életkorra képletekkel

Az alábbi képletek segíthetnek az életkor kiszámításában az Excel születési dátuma alapján.

Konvertálja a születési dátumot életkorra az INT funkcióval

Az INT funkció segíthet az adott személy életkorának kiszámításában a megadott születési dátum alapján. Kérjük, tegye a következőket.

1. Tételezzük fel, hogy két oszlop tartalmazza a születési dátumot és az aktuális dátumot külön-külön.

2. Válasszon egy üres cellát az életkor kiadásához, írja be az alábbi képletet, és nyomja meg a belép kulcs. Válassza ki az eredmény cellát, majd húzza át Töltse meg a fogantyút minden eredmény elérése érdekében.

=INT((B2-A2)/365)

Konvertálja a születési dátumot életkorra a DATEDIF funkcióval

Az alábbi DATEDIF funkció szintén segíthet.

Válasszon egy üres cellát az életkor kiadásához, írja be az alábbi képletet, és nyomja meg a belép kulcs. Válassza ki az eredmény cellát, majd húzza át Töltse meg a fogantyút minden eredmény elérése érdekében.

=DATEDIF(A2,NOW(),"y")

Konvertálja a születési dátumot életkorgá a ROUNDDOWN funkcióval

Próbálja ki a ROUNDDOWN funkciót az életkor születésnapi alapon történő kiszámításához, az alábbiak szerint.

Válasszon egy üres cellát az életkor kiadásához, írja be az alábbi képletet, és nyomja meg a belép kulcs. Válassza ki az eredmény cellát, majd húzza át Töltse meg a fogantyút minden eredmény elérése érdekében.

=ROUNDDOWN(YEARFRAC(A2, TODAY(), 1), 0)

Az életkor megjelenítése Év + Hónap + Nap formátumban a DATEDIF funkcióval

Ha az életkort év + hónap + nap formátumban szeretné megjeleníteni, próbálkozzon az alábbi DATEDIF funkcióval.

Válasszon egy üres cellát az életkor kiadásához, írja be az alábbi képletet, és nyomja meg a belép kulcs. Válassza ki az eredmény cellát, majd húzza át Töltse meg a fogantyút minden eredmény elérése érdekében.

=DATEDIF(A2,TODAY(),"Y") & " Years, " & DATEDIF(A2,TODAY(),"YM") & " Months, " & DATEDIF(A2,TODAY(),"MD") & " Days"


Könnyen átalakíthatja a születési dátumot életkorra képletekre nem emlékezve

Könnyen átalakíthatja a születési dátumot életkorra anélkül, hogy emlékezne a képletekre a Dátum és idő segítő of Kutools for Excel. 

Alkalmazás előtt Kutools for ExcelKérjük, először töltse le és telepítse.

1. Válasszon egy üres cellát az életkor kiadásához. Ezután kattintson a gombra Kutools > Formula Segítő > Dátum és idő segítő

2. Ban,-ben Dátum és idő segítő párbeszédpanelt, kérjük, konfigurálja az alábbiak szerint.

  • 2.1) Menj a Kor fül;
  • 2.2) A Születési idő mezőben válassza ki azt a cellát, amely tartalmazza az életkorra konvertálandó születési dátumot;
  • 2.3) Válassza a lehetőséget Ma lehetőség a Nak nek szakasz;
  • 2.4) Adjon meg egy eredménytípust a Kimeneti eredmény típusa legördülő lista;
  • 2.5) Kattintson a gombra OK gombot.

Ezután az életkor a kiválasztott cellába kerül. Jelölje ki az eredmény cellát, majd húzza le teljesen a Kitöltő fogantyút, hogy minden korosztályhoz hozzájusson.

Megjegyzések: Ha az életkort év + hónap + nap formátumban szeretné megjeleníteni, kérjük, válassza a lehetőséget Év + hónap + nap tól Kimeneti eredmény típusa legördülő lista. Az eredmény pedig az alábbi képernyőképen jelenik meg. Támogatja az életkor hónap, hét vagy nap szerinti megjelenítését is az Ön igényeinek megfelelően.

  Ha ingyenes (30 napos) próbaverziót szeretne kapni a segédprogramról, kattintson a letöltéshez, majd lépjen a művelet végrehajtására a fenti lépések szerint.


Kapcsolódó cikkek:


A legjobb irodai termelékenységi eszközök

A Kutools for Excel megoldja a legtöbb problémát, és 80% -kal növeli a termelékenységet

  • újrafelhasználás: Gyorsan helyezze be összetett képletek, diagramok és bármi, amit korábban használt; Cellák titkosítása jelszóval; Levelezőlista létrehozása és e-maileket küldeni ...
  • Szuper Formula Bár (könnyedén szerkeszthet több szöveget és képletet); Olvasás elrendezés (könnyen olvasható és szerkeszthető nagyszámú cella); Beillesztés a Szűrt tartományba...
  • Cellák / sorok / oszlopok egyesítése az adatok elvesztése nélkül; Osztott cellák tartalma; Kombinálja a duplikált sorokat / oszlopokat... megakadályozza az ismétlődő cellákat; Hasonlítsa össze a tartományokat...
  • Válassza a Másolat vagy az Egyedi lehetőséget Sorok; Válassza az Üres sorok lehetőséget (az összes cella üres); Super Find és Fuzzy Find sok munkafüzetben; Véletlenszerű kiválasztás ...
  • Pontos másolás Több cella a képletreferencia megváltoztatása nélkül; Automatikus referenciák létrehozása több lapra; Helyezze be a golyókat, Jelölőnégyzetek és még sok más ...
  • Kivonat szöveg, Szöveg hozzáadása, Eltávolítás pozíció szerint, Hely eltávolítása; Hozz létre és nyomtasson személyhívó részösszegeket; Konvertálás a cellatartalom és a megjegyzések között...
  • Szuper szűrő (mentse el és alkalmazza a szűrősémákat más lapokra); Haladó rendezés hónap / hét / nap, gyakoriság és egyebek szerint; Speciális szűrő félkövér, dőlt betűvel ...
  • Kombinálja a munkafüzeteket és a munkalapokat; Táblázatok egyesítése kulcsoszlopok alapján; Az adatok felosztása több lapra; Kötegelt konvertálás xls, xlsx és PDF...
  • Több mint 300 hatékony funkció. Támogatja az Office / Excel 2007-2019 és 365. Támogatja az összes nyelvet. Könnyen telepíthető a vállalkozásba vagy szervezetbe. 30 napos ingyenes próbaverzió. 60 napos pénzvisszafizetési garancia.
kte tab 201905

Az Office fül a füles felületet hozza az Office-ba, és sokkal könnyebbé teszi a munkáját

  • Füles szerkesztés és olvasás engedélyezése Wordben, Excelben és PowerPointban, Publisher, Access, Visio és Project.
  • Több dokumentum megnyitása és létrehozása ugyanazon ablak új lapjain, mint új ablakokban.
  • 50% -kal növeli a termelékenységet, és minden nap több száz kattintással csökkenti az egér kattintását!
officetab alja
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Thom h · 5 years ago
    @Steve Konz Excellent function, Steve. I believe datedif also does consider leap years :) yours looks very similar to something I wrote a couple of years ago add the client wanted to account for leap years and didn't trust datedif
  • To post as a guest, your comment is unpublished.
    Thom h · 5 years ago
    @Chris Just create a macro to take the selected cell, and dump the Function next to it, referencing that cell. You'll need to look in another thread to find macro guidance. It just drag the cell down
  • To post as a guest, your comment is unpublished.
    Thom h · 5 years ago
    @ebeckin Not entirely sure of what you're after but I assume you want it to round down thus giving the exact age? In which case you can use rounddown() or I believe floor() will also do the trick.
    Thanks, thom
  • To post as a guest, your comment is unpublished.
    Jaspreet · 5 years ago
    Hello
    Retirement age is 60 years and last date of each month and the formula works, but in our case if an employee's date of birth falls on 1st of any month then he/she will retire on the previous months last date. (eg. employee 1 DOB is 03/01/1960 then output needed is 28-02-2020 and employee 2 DOB is 03/02/1960 then 31-03-2020)
  • To post as a guest, your comment is unpublished.
    Miranda Creed-Miles · 5 years ago
    Brilliant tips!
    Really worked well! If you want the age to display as a single number on Method B - just format the cell to 'Number' with no decimal points - it works!! Hurrah!!
  • To post as a guest, your comment is unpublished.
    Channing · 5 years ago
    Literally none of these worked. When I subtract, it just gives me another date like 03/03/1953
  • To post as a guest, your comment is unpublished.
    Atomicpetro · 5 years ago
    Another question in regards to age. How can I get the age in cell B2 [age?] when I have in Cell A2 [26/06/1966] and in Cell B1 [2013] just the year. Thanks.
  • To post as a guest, your comment is unpublished.
    guru · 5 years ago
    @Thom H Hi,,,

    you only looking this only ya,,, :-)
  • To post as a guest, your comment is unpublished.
    guru · 5 years ago
    It is Nice i think it good to learn to Excel 8) :roll: :P
  • To post as a guest, your comment is unpublished.
    Steve Konz · 5 years ago
    Here is one i have that accounts for leap days (well it excludes them pretty much)


    =IF((DATEDIF((DATE((YEAR(C3)+(DATEDIF(C3,C2,"y"))),MONTH(C3),DAY(C3))),C2,"d"))=365,(DATEDIF(C3,C2,"y"))+((DATEDIF((DATE((YEAR(C3)+(DATEDIF(C3,C2,"y"))),(MONTH(C3)),(DAY(C3)))),C2,"d")-1)/365),(DATEDIF(C3,C2,"y"))+((DATEDIF((DATE((YEAR(C3)+(DATEDIF(C3,C2,"y"))),(MONTH(C3)),(DAY(C3)))),C2,"d"))/365))

    C2 = Current Date - could use TODAY()
    C3 = DOB
  • To post as a guest, your comment is unpublished.
    Steve Konz · 5 years ago
    Not sure if this was covered, but a lot of people right these and don't consider leap years when looking at the difference in days. Here is one I wrote that considers leap year rules (even for the 100 & 400 year rules)....


    =IF((DATEDIF((DATE((YEAR(A2)+(DATEDIF(A2,A1,"y"))),MONTH(A2),DAY(A2))),A1,"d"))=365,(DATEDIF(A2,A1,"y"))+((DATEDIF((DATE((YEAR(A2)+(DATEDIF(A2,A1,"y"))),(MONTH(A2)),(DAY(A2)))),A1,"d")-1)/365),(DATEDIF(A2,A1,"y"))+((DATEDIF((DATE((YEAR(A2)+(DATEDIF(A2,A1,"y"))),(MONTH(A2)),(DAY(A2)))),A1,"d"))/365))


    where A2 is the date of birth, and A1 is the current date (which could be replaced with TODAY() also.

    Please let me know if there are any flaws in this or simpliar ways to calculate it.
  • To post as a guest, your comment is unpublished.
    Chris · 5 years ago
    Method D is exactly what I've been looking for, minus the day portion (easily removed). I've created an inventory of PCs for my company, and am using this to calculate hardware age based on purchase date. My question is this - is there a way to take this formula and make it so that I can essentially click a button to have it applied to a cell, and then just be able to then select the cell I want it to do the calculation on? Otherwise, I'm looking at having to copy/paste the formula to several hundred cells, and then go and manually change the target cell in each one.

    Thanks.
  • To post as a guest, your comment is unpublished.
    Shephard · 5 years ago
    Hello,
    I have added the formula for age that works well. I was able to continue the formula down the entire column which is what I needed. The issue is that a computed "age" appears in each cell despite the fact that I have not filled in a birthdate. ie: everything below the correct calculations in the column reads 115 years as a default. Is there a way to make the age cell blank until a value is placed in the birthdate cell so as not to see ongoing "115's?" Thanks in advance~
  • To post as a guest, your comment is unpublished.
    ebeckin · 5 years ago
    @thomh Hi Thomh or any other experts,

    I would like to be able to calculate an age (rounded down to years only) that is the difference between a particular date (the date a patient was referred) and their birthdate so that I end up with the age they were when they were referred by their GP. The date of birth is in field C2 and the referral date is in field D2. I'm not very good at Excel so I'm being specific about this so I can just copy/paste your formula. I've tried using FLOOR and ROUNDDOWN but I'm obviously doing something wrong. I can get a value like 7.8856 by entering =(g2-c2)/365 but if I remove the digital places to one, it rounds it up to 8, which I don't want. Can anybody help me, please? :)
  • To post as a guest, your comment is unpublished.
    raksmey · 6 years ago
    I really appreciate with this fomular.
    :D
  • To post as a guest, your comment is unpublished.
    Thom H · 6 years ago
    @KELSEY Hi Kelsey,

    Option B (DATEDIF()) only gives you the years as a number value - did you perhaps mean option D? I've added an IF statement to Option B, so that it only shows the months and yeards if the person is 2 or under:
    =IF(DATEDIF(A2,NOW(),"y")
  • To post as a guest, your comment is unpublished.
    KELSEY · 6 years ago
    I like the "Method B" format when figuring out the age. I'm wondering if there is a way to have the years old and just the months old if younger than 2 using that format. Thanks!
  • To post as a guest, your comment is unpublished.
    Krista · 6 years ago
    @Thom H Oops. LOL I had drafted this long note to you telling you it was still not working, when I noticed you were right...cell E13 was empty. My son's DOB is in cell E15. Oops. LOL Thanks for your kind help. It's working now. :) Have a great day!!
  • To post as a guest, your comment is unpublished.
    Thom H · 6 years ago
    @Krista Hi Krista,
    That would be the length of time since Excel's callander started :P

    You're getting that because the cell you're referencing is blank - is you r son's DOB in Cell E13? Because that's the Cell it's calculating from.

    Possible fixes:
    - Your function contains errors, please see the corrected one below:
    =DATEDIF(E13,TODAY(),"Y") & " Years, " & DATEDIF(E13,TODAY(),"YM") & " Months, " & DATEDIF(E13,TODAY(),"MD") & " Days"

    - You need to use the format option to format it correctly as a date. i.e. to make it read in that format you'll need to go to the 'Custom' option under format and enter:[$-809]dd-mmm-yy;@ Under 'Type'

    - If you're just typing it in like that, it probably won't read it as a date, you need to enter it as 11/02/2003

    This will give you "12 Years, 1 Months, 1 Days"

    Thanks,

    Thom
  • To post as a guest, your comment is unpublished.
    Krista · 6 years ago
    Hello, I have a column in my spreadsheet for birth date, that is formatted as DD-Mon-YY (ie 11-Feb-03 for my son that was born on February 11, 2003). I used the =DATEDIF function referenced above and it is returning 115 Years, 2 Months, 11 Days. What is wrong and how do I correct it? Thanks for your help.
    =DATEDIF(E13,TODAY(),"Y") & " Years, " & DATEDIF(E13,TODAY(),"YM") & " Months, " & DATEDIF(E13,TODAY(),"MD") & " Days"
    Note: When I type =today() in a cell it is correctly listing 11-Mar-15 as today's date.
    Also note: The regional settings in my control panel list short date as dd-MMM-yy, so I don't think this would be the problem.
  • To post as a guest, your comment is unpublished.
    Thom H · 6 years ago
    @Kimberley Woodward Hi Kimberley,
    Datedif would do that for you, Just use =DATEDIF(A1,TODAY(),"m") Assuming the DOB is in Cell A1.
    Thanks,
    Thom
  • To post as a guest, your comment is unpublished.
    Thom H · 6 years ago
    @Tanja Hi Tanja,

    I'm assuming that would be the 25th October 2002? Is the FX part of the box? If so, I'd start with =right(A1,8) which would give you the last eight digits from cell A1, so if Cell A1 contained "fx 25102002" it would simply return "25102002". Now to convert that 8 digit string into a palatable date, I'd use the =date() function. I've done one for you, you just need to switch the A1 with the cell that contains your function =DATE(RIGHT(A1,4),RIGHT(LEFT(A1,4),2),LEFT(A1,2))
    Thanks, Thom
  • To post as a guest, your comment is unpublished.
    Thom H · 6 years ago
    @B Kumar Hi B Kumar,
    I'm afraid I don't follow your question. Could you please clarify for me?
    Thanks, Thom
  • To post as a guest, your comment is unpublished.
    Thom H · 6 years ago
    @Manoj Hi Manoj,
    You wouldn't really be able to get the exact date of birth, unless you knew how old they were exactly i.e. 20 years, 50 days. You could calculate it to year by doing something like =YEAR(TODAY())-A1 assuming their current age was in Cell A1.
    Thanks,
    Thom
  • To post as a guest, your comment is unpublished.
    Tanja · 6 years ago
    Hi,

    How do I convert fx 25102002 into a date and than age?
  • To post as a guest, your comment is unpublished.
    Kimberley Woodward · 6 years ago
    hi what would the formula be to work out a child's date of birth in exact months (so 24/02/13 = 24mths?)

    I am an early years teacher and we work in months not years and months.

    Can you help?

    Kimberley
  • To post as a guest, your comment is unpublished.
    rowena · 6 years ago
    Hi thanks! ;-)
    Its abig help for me having your tips....
  • To post as a guest, your comment is unpublished.
    B Kumar · 6 years ago
    Hi Thom,
    Kindly Help me i am not understand this formula.
    Please calculate my date of birth explained me my date of birth 15/09/1988
  • To post as a guest, your comment is unpublished.
    Carlos Somarriba · 6 years ago
    Great!!! All formulas works perfect. Thank you so much.
  • To post as a guest, your comment is unpublished.
    Manoj · 6 years ago
    Is there any way to convert age into date of birth. I have a sheet with name and age of customers as if age in years only. Is there any way to have DOB as result
  • To post as a guest, your comment is unpublished.
    Pedro · 6 years ago
    Its was very easy to follow and all the possible options for me to decide which was the best that accommodate my needs. Thanks :-) ;-) :lol:
  • To post as a guest, your comment is unpublished.
    Tanmay Chanda · 6 years ago
    Its Very helpful many many thanks.....
  • To post as a guest, your comment is unpublished.
    David84* · 6 years ago
    Many thanks for this, just got me out of a tight spot at work! Stay classy, excel geniuses.
  • To post as a guest, your comment is unpublished.
    Thom H · 6 years ago
    @Dai_Green Hi David,
    Please can you copy and paste in the functions you used and the results so that I know the exact format you're working with here?
    Thanks
    Thom
  • To post as a guest, your comment is unpublished.
    Thom H · 6 years ago
    @Carrie Pool Hi Carrie,

    That's difficult because it may well be a year out without the EXACT age (81.0223 sort of format) as they may well have a birthday in December but you calculate it as at June, meaning it would calculate their age at 81 when in actual fact they're still only 80.

    Assuming the age at death is in box A1 and the current date is in B1 (You could replace references to B1 with the =today() function if you'll ony use this ones):

    =DATE(YEAR(B1)-A1,MONTH(B1),DAY(B1))

    This calculates the given age from the year value of the current date.

    Kind regards,

    Thom
  • To post as a guest, your comment is unpublished.
    Thom H · 6 years ago
    @aamir khan Hi Amir,

    This is covered in Method D (Using your first date instead of the DOB and you'll need to take the today() functions out of method D and replace them with your end date, or a cell reference for the cell containing the end date, so if in your example you have 12/06/1983 in call A1 and 1/1/2014 in cell B1 then in cell C1 you could put:

    =DATEDIF(A1,B1,"Y") & " Years, " & DATEDIF(A1,B1,"YM") & " Months, " & DATEDIF(A1,B1,"MD") & " Days"

    Don't forget that if you have a list and you drag this function down then the cell references will auto update as you pull them down i.e A1 will become A2 then A3..

    If you have lots of start date but the end date will always be the value of call B1 then you can lock that cell reference (Make it absolute) but using Dollar signs so instead of writing B1 you'd put $B$1

    Thanks,

    Thom
  • To post as a guest, your comment is unpublished.
    Thom H · 6 years ago
    @Lucy Hi Lucy,

    I'd need more context as to what you're trying to set up, how it's done and your chosen function but it looks as though you've put the age function into the third column then you're dragging it down? If you check each function and just make sure the correct cells are referenced this should do the trick.

    #VALUE errors tend to mean that you're using referencing cells that don't contain data in the format the function expects. In this case the functions are looking for dates so Excel may well have converted your dates into text format? Easy fix = highlight the date cells, right click, format cells, format as date.

    If that doesn't work you'll need to create a secondary column next to each one (Which you can later hide) then use the =date() function to convert them into date format (see my reply to sanoj xavier further down the page for info on this function).

    Thanks,

    Thom
  • To post as a guest, your comment is unpublished.
    Thom H · 6 years ago
    @she Hi Robyn,

    The Cell you wish to round down should be inside of the parentheses i.e. if you are rounding down cell A1 it would be =Floor(A1)
  • To post as a guest, your comment is unpublished.
    Khalil ur Rehman · 6 years ago
    =(DATEDIF(A1,TODAY(),"Y")& " Years, " &DATEDIF(A1,TOD AY(),"YM")& " Months, " &DATEDIF(A1,TOD AY(),"MD")& " Days)
    is very helpful for me in my office.

    Thanks
  • To post as a guest, your comment is unpublished.
    thomh · 6 years ago
    @CI Hi CI,

    Put your chosen function into an =if() function like:
    =if(CHOSENFUNCTION=CELLCONTAININGENDDATE,CELLCONTAININGENDDATE,CHOSENFUNCTION)
    IF the function you choose is equal to the value in your chosen cell then it will return the value of said cell if not, it will keep calculating.
    thanks,
    thom
  • To post as a guest, your comment is unpublished.
    thomh · 6 years ago
    @satheesh Hi Satheesh,
    It was added around about then so it should work, but you won't get any autosum assistance, you'll have to type it blind. personally, I tend to avoid autosum anyway (once you get into advanced functions it just gets in the way)
    thanks,
    Thom
  • To post as a guest, your comment is unpublished.
    thomh · 6 years ago
    @sanoj xavier Hi Sanoj,
    you'll need to convert it into a correctly formatted date first. then you can use any of the above functions. I'd recommend either doing this with a function in the column next to it, then referencing that column in your chosen function.
    If you're feeling confident enough in excel you could try making a long argument by putting the conversion function into the age calculation function.

    here's an example of what you could use, assuming "19610821" is in cell A1

    =DATE(LEFT(A1,4),LEFT(RIGHT(A1,4),2),RIGHT(A1,2))

    let me know how you get on.

    regards,
    Thom
  • To post as a guest, your comment is unpublished.
    AP · 6 years ago
    The [i][b]Datedif[/b][/i] function is very helpful& the best....... Thnks a lot
  • To post as a guest, your comment is unpublished.
    Dai_Green · 6 years ago
    Hi all - Need a bit of help. Please??

    I have date of births, and have used the DATEDIF formula to work out the Year and Month of each individual at 2 different points in time.

    For Example In May I know Joe is 10 Years, 5 Month but he is only achieving as child of 8 Years, 10 Month. So I want to subtract 1 from the other. So I have an answer of how many Year, Month he is behind. Any Suggestions??

    Thank you,

    David
  • To post as a guest, your comment is unpublished.
    Carrie Pool · 6 years ago
    I have a death date and the exact age at time of death. I need to use this information to calculate a date of birth. Can anyone help me with the formula for this?
  • To post as a guest, your comment is unpublished.
    Juliemichaela · 6 years ago
    Can anyone please help?! I have created an Excel spreadsheet. So far so good! Under the 'Client Details' tab are different headings including in column A: Status (the two options being 'client' or purely an 'enquiry'), column B: First Name, column C: Surname, Column D: Email Address and so on.
    I have then created a different tab within the same worksheet entitled 'Enquiries'. I want to insert a formula in this tab that will automatically copy across from the 'Client Details' tab the whole line of data for all entries that have a Status of 'Enquiry' displayed in column A.
    Can anyone please help?
    Many thanks, Julie
  • To post as a guest, your comment is unpublished.
    AMIT · 6 years ago
    @Berjang Pun [quote name="Berjang Pun"]:lol: it is helpful for me[/quot
    VERY EASY TO KNOW THE DATE OF BIRT COUNT AS YEARLY AGE..?
    YOU CAN ..AS BELOW
    10/8/1980-TODAY DATE=?????? THEN YOU CAN / BY 365 EASILY U WILL GETS THE POINT..
  • To post as a guest, your comment is unpublished.
    JAGDISH BAUDH · 6 years ago
    hi how calculate age column wise exmp- 1- day 2- month 3- years
  • To post as a guest, your comment is unpublished.
    CI · 6 years ago
    Hi, If I use the formulas provide I would need the age to not advance even if they have a birthday tomorrow. For example if I use the formula today 08/15/2014 and they have a birthday of 08/16/2014 I need the spreadsheet to essentially lock or remember the age on 08/15/2014.

    Thanks
  • To post as a guest, your comment is unpublished.
    she · 6 years ago
    @Thom H [quote name="Thom H"]=FLOOR() would also do the trick[/quote]
    how is this being used? () what should be inside this parentheses?