Fun.Think.Wonder - Mabzicle <script type='text/javascript' src='//platform-api.sharethis.com/js/sharethis.js#property=5d3314afc65d660012fcc47b&product=social-ab' async='async'></script>

HOW TO: Calculate Age and Sort Monthly for the Birthdays using Microsoft Excel

Sort out a list of people from youngest to oldest and categorically arrange by month with the given birthdate using Microsoft Excel!

Sometimes, you need to sort out a list of people from youngest to oldest and categorically arrange by month with the given birthdate using Microsoft Excel to increase productivity and easier access.

This could be tough and complicated but somehow it kinda helps you play some functions.

Some EXCEL functions used:
  • The DATEDIF function is useful in formulas where you need to calculate an age.
  • The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.
  • The NUMBERVALUE function is useful when you convert text to a number, in a locale-independent way.
  • The TEXT function is useful when you change the way a number appears by applying to format to it with format codes.

HOW TO: Calculate Age
  • Using Function =DATEDIF()
    • Syntax: =DATEDIF(start_date,end_date,unit)
    • Sample: =DATEDIF(E4, NOW(),"y") where E4 is the birthdate field (m/d/yyyy), "y" to fetch and result for year.
1. First, you need to add some header titles on top row or wherever you want to add. Here I put it on the first row with the following header titles like:
  • #
  • Lastname
  • First name
  • Birthdate
  • Status
  • Age
  • Sex
  • MM
Since we are getting the age the most important here is just the birthdate and age cell.
Important: I usually add # or No. on headers for me to easily sort on the later part of the project.

2. Then I used some dummy information for calculating the Age. It may look like this.


3. The highlighted row and column will be used to our Function
  • =DATEDIF(start_date,end_date,unit)
start_date = D2 and D3 (hightlighted cell) ; should be mm/dd/yyyy;
end_date = now() function ; we will compare D2 and D3 to this moment.
unit = we will be used "y" for the year.


4. So in the AGE cell (especially D2 - Juan de la Cruz), we will put the formula in that cell. Notice that I put =DATEDIF(D2, NOW(),"y") in D2 and D3, and you will see the age result.
  • If you differentiate 1965 (January 5) and 2018(August 13), you will get  53.
  • If you differentiate 1970 (April 25) and 2018(August 13), you will get  48

HOW TO: Sort Birthdays According to Month

If you want to know how many birthday celebrants on a certain month, or the next following month, this could be useful tip and function. Here, I added three(3) examples to see if it works well.


Notices: 
  1. I added 3 persons namely:  Victor, Elen, and Juan Luna.
  2. MM Header title (it should be the container for sorting for the monthly)
  3. # very useful in the sorting process. Once you want to get the original arrangement, you can always sort it according to #.
1. Now, we add a text =NUMBERVALUE(TEXT())
  • =NUMBERVALUE(TEXT(D2,"MMDD")) where E3 is the cell or the birthdate
  • MMDD will fetch month and day.

TIP: Drag the corner to copy the formula(D2, D3, D4, D5, D6) without editing the cell interactively. See below.


2. Select the title header then click Sort and Filter as shown below.


Sort and Filter help you sort things on those same headers (that's why I always put No. field).

3. Click Filter, you will notice there is an arrow on the cell.


4. Choose MM cell, then click the arrow and you will see sort smallest to largest or largest to smallest. You can try the two and it will sort.


5. This is the result of the Sort Smallest to Largest


Notice the order: the first is January 5, then January 10, then April 15, April 25, and last May 5 in order.

FINAL THOUGHTS
To recap, I used these EXCEL functions:
  • The DATEDIF function is useful in formulas where you need to calculate an age.
  • The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.
  • The NUMBERVALUE function is useful when you convert text to a number, in a locale-independent way.
  • The TEXT function is useful when you change the way a number appears by applying to format to it with format codes.
Useful Excel Function: Convert Numbers into Words

I hope you will find it useful especially creating a master list with birthdate. Feel free to comment below. Thank You!
Name

2012 Summer Olympics,1,2012 Year End Special,1,2012.,1,2014 Movies,3,2015 Movies,6,2016 Movie,3,3D Movie,1,3G,1,3GPP Long Term Evolution,1,4G,3,4K Technology,2,64-bit,1,802.11,1,8K Resolution,1,ABC,1,Abroad,1,Accessories,1,Acer,3,Acquisition,2,ACT,1,Action Movie,4,AD,1,Ad Network,1,ADATA,1,Addictive,1,addons,2,Adfly,4,Adobe,3,Adobe Flash Player,1,Adobe Photoshop,7,Adobe Photoshop CC,1,Adobe Shockwave,1,Ads Skipper,1,Advanced Info Service,1,Adventure,2,advertising,2,Advisory,1,Adwords,1,agile project management tool,1,Agua Vortex,1,AI,1,Airline,1,Airtel,1,Alcatel,3,Alcatel Flash Plus 2,1,Alert,1,Alexa,1,Alexa Rank,1,All-in-one,1,amazon,2,AMD,4,AMD Radeon R9,1,American,1,Android,49,Angel Locsin,1,Angry Birds,2,Animation,1,Anime,6,Announcement,1,Anonymous,1,Anti-Child Pornography,1,Antivirus,4,AOL,1,App,29,App Store,4,Apple,16,Apple iPhone 5,2,Appliance,1,Application,17,Apps,6,Arena of Valor,1,Art,1,Assassin's Creed,1,Astrology,1,Asus,4,ATAP,1,ATM,1,Attack on Titan,2,ATX,1,Auslogics,1,Automation,1,Automobile,1,AutoRun,1,Awards,3,Awesome,2,Backpack,1,Backup,1,Bag,1,Band,1,bandwidth,1,Bank,2,Banking,2,Basketball,1,Battery,1,Battle Pass,2,BayanTel,1,Behavior,1,Big Hero 6,1,Bill,1,Biology,1,BIOS,2,Biotech,2,BisRock,1,Bitcoin,1,BitTorrent,2,BlackBerry,6,BlackBerry 10,1,Blackphone,1,Blizzard,1,Blockchain,1,Blog,4,Blogging,4,Blogopolis 2012,1,BOC,1,BoostSpeed,1,BoostSpeed 8,1,Boot,1,Boot Camp,1,Boxing,1,BPI,1,Bradley,1,BroadBand,7,Browser,10,Business,15,Bypass Countdown on Ads,1,Cable,4,Calling,1,Camera,14,Campaign,2,Candy Crush Game,1,Canon,1,Car Technology,6,Cars,4,Cash Out,8,CAT,1,CCTV,1,ccZen,1,CDO,1,Celebration,8,Celebrity,3,Cell Sites,1,CEO,1,CES,1,CES 2014,11,CES 2015,4,CES 2017,1,CES 2018,1,Challenge,1,Charging,1,Cheap,1,CheatSheets,5,Cherry Mobile,19,Cherry Mobile Flare,3,Cherry Mobile Flare S5 Power,1,Chip,2,Chipset,3,Chrome,2,Chrome OS,1,ChurpChurp,1,Cine-Phone,1,CISCO,3,CISPA,1,Civil Service,2,classified ads,1,ClixSense,8,Cloud,1,CMD,2,Coca Cola,3,Coca Cola Promo,2,Codes,2,Coffee,1,color,1,Comic-con,1,Comics,1,Company,7,Competition,3,Complaint,1,Computer,2,Computer virus,1,Computing,1,Concept,3,Connection,2,Console,1,Convergys,1,Converter,1,Cool,2,Cool Gadgets,5,CopyPaste,1,Corning,2,Cosmos Series,2,Counter-Strike,1,cp tricks,5,CPU,1,creative project management software,1,Creature,1,Crime,1,CRM,1,Cryptocurrency,1,CS,1,CSC,18,CSC Exams,12,CSC Form,1,CSE 2013,1,CSE Exam,3,CSE October 21,1,CSS,1,CSS Tips,1,Cube,1,Curiosity,1,Customer,1,Customer Service,1,CW,1,cybercrime prevention act,1,Data Rate,1,Data Transfer,2,Database,1,DC,5,DC Comics,3,DDR4,1,Deals,1,Dedicated,1,Defaced,1,Dell,1,Depression,1,Design,5,Designs,17,Desktop,2,Devant,2,Devant TV,1,Developers,3,Devices,12,DICT,1,Digg,1,Digital Marketing,4,Digital Storm,1,DILG,1,Direct Download,1,DirectX,2,DirectX 12,1,Disney,5,Display,2,Disqus,1,DIY,1,DMCA,1,Document,1,DOJ,1,DOLE,1,Domain,5,DoT,1,Dota 2,11,DotA Map,4,Dota2,3,Dota2 7.00,1,Dragon Ball,1,DragonBound,1,Drivers,1,DSLR,2,DSLT,1,Du30,1,Duracell,1,E-Commerce,1,E-Load,1,Ear,1,Earn Credits,1,Earn Money,128,Earth Hour,2,Earthquake,1,EaseUS,2,Ebook,1,Education,3,Eidul-Fitar,1,Election,3,Election 2013,3,Electricity,1,Electronics,2,Email,1,EMGOLDEX,1,Engineering,1,Entertainment,7,Entrepreneur,2,epic games,1,ePub,1,ePub Reader,1,Equipment,1,ESET,3,Esport,3,Esports,1,Ethics,1,Etiquette,1,Events,6,Evernote,1,Exam Result,1,Exclusive,4,explained,1,Exploit,2,extension,5,External Drive,1,Facebook,92,Facebook Application,11,Facebook Comment Plugin,1,Facebook Cover Photo,1,Facebook Features,10,Facebook Game,2,Facebook Graph Search,2,Facebook Messenger,3,Facebook Page,1,Facebook Plugin,1,Facebook Privacy,1,Facebook Shortcut Keys,1,Facebook Smiley,1,Facebook Status,1,Facebook Themes,1,Facebook Timeline,1,Facts,3,Fair Use Policy,1,Fantasy,1,Farm Ville,1,Farm Ville 2,1,Fashion,1,Father's Day,1,Feature,8,Featured,5,Featured Post,3,Features,16,Federal Bureau of Investigation,1,Feeds,1,Festival,1,Fiction,1,Fiesta,1,Fifa,1,File,1,File Management,1,Filipino,1,Film,4,Finance,3,Firefox OS,1,First iPhone,1,Fitness Band,2,Fitness Tracker,1,Flappy Bird,2,Flickr,1,Flight MH370,1,Font Manager,1,food,2,Ford,2,Ford Ranger 2012,1,Forever 21,1,Forms,1,fortnite,1,Fox,1,free,10,Free Internet,36,free online collaboration tools,1,Free SMS,2,Free Stuff,4,Free Twitter,1,Freebies,5,Freelance,1,Freelancer,1,Freemium,3,Freeware,4,Fuego Ignite,1,FuelBand,1,Fun,1,FUP,1,Fusion,1,Fusion Bolt,1,G1,1,Gadget,7,Gadgets,24,Galaxy Forever Plan,1,Galaxy Round,1,Game,31,GameBoy,1,Gamepad,1,Gameplay,1,Games,20,Gaming,16,Gangnam Style,1,gantt chart,1,gantt chart maker,1,geek,2,GeForce GTX,1,General Information,4,Gerard Butler,1,Giraffe Riddle,1,Globe,134,Globe 0917 Blogger,1,Globe App,1,Globe Blue,1,Globe Labs,2,Globe myBusiness,1,Globe Platinum,1,Globe Postpaid,9,Globe Prepaid,7,Globe Press Release,45,Globe Promo,8,Globe Rewards,6,Globe Tattoo,5,Globe Telecom,112,Globe Video,1,gmail,2,Goal Visual,1,Godzilla,1,GoldXtreme,1,Google,127,Google AdSense,10,Google Adsense Keywords,1,Google Assistant,1,Google Authorship,1,Google Chrome,5,Google Chromecast,1,Google Concept,1,Google Doodle,20,Google Doogle,32,Google Earth,1,Google Earth Pro,1,Google Extension,1,Google Game,1,Google Interactive,3,Google Keep,2,Google Nexus 7,2,Google Page Rank,1,Google Play,3,Google Produce,1,Google Products,2,Google Promo,1,Google Reader,1,Google Street View,1,Google Time,1,Google Tributes Collection,3,Google Trick,2,Google Web Designer,1,Google+,5,Google+ ShortTags,1,GoPro,2,GoSurf,1,GoUNLI,1,GovNet,1,GPU,3,Graduation 2013,2,Graphics,5,Graphics Card,7,greasemonkey,1,Guide,1,Guidelines,1,Hack,3,Hackers,2,Haiyan,1,Halloween,3,Hands On,2,Hard Disk,11,Hard Drive,5,Hardware,20,Hardware Issue,3,Harry Potter,2,Health,15,Health Tips,8,Hearthsone,1,Hermann Rorschach,1,HGST,1,Highest Paying Keywords,1,Hilux 2012,1,History,2,Hoax,11,Holiday,5,Holidays,14,Holidays 2013,6,Holidays 2015,1,Holograms,1,Horror,1,How TO,103,How to Display Image Web Result,1,HP,3,HR,1,HTC,3,HTC One,2,HTC One Max,1,HTML 5,1,Huawei,5,Huawei Ascend Mate 2,1,Huawei Nova,1,HUG ME,1,Humanity,1,Humor,1,IBM,1,Icons,2,Idea,1,IEEE,1,Illustrator,1,Incident,1,Increase Website Traffic,4,Infographic,10,infographics,6,Infolinks,6,Information,3,Inmarsat,1,Innovation,3,Insidious 3,1,Inspirational,1,Instagram,5,Intel,4,Interesting,1,Interface,1,Internet,8,invention,2,Investment,6,Invitation,1,Iobit,1,iolo technologies,3,iOS,12,iPad,1,iPhone,13,iPhone 5C,1,iPhone 5s,4,iPhone 6s,2,ISP,2,Issues,14,IT,1,Jack Daniel,1,James Bond,1,Japanese,1,Jason Bourne,1,Java,3,Java Apps,1,Java Games,1,Javascript,1,JK Rowling,1,Job,2,Job Hiring,9,Job Search,7,JobStreet,1,Jquery,1,JS,1,JuanKonek,1,July 9,1,Justin Beiber,2,K-Pop,1,Kat.PH,1,Kennedy Space Center,1,Kepler Space Telescope,1,Kepler-186f,1,Keyboard,1,kickstart,1,Kickstarter,1,KimStore,1,Kingston,1,Kitkat,1,Klout,1,Kodak,1,Lady Gaga,1,Lamborghini,1,Language,2,Laptop,5,Law,7,Lawsuit,1,Lazada,4,Leaks,3,Learning,1,LED,1,LEGO,1,Lenovo,4,Lessons,2,Lexus,1,LG,10,LG Electronics,2,LG G Pad,1,LG G Pro 2,1,LG G2,1,LG G3,2,Li-Fi,1,LibrengTawag,1,Life Hacks,1,Life Style,2,LinkedIn,1,Linux,1,List,1,Live-Action,1,Location Map,1,Logitech,1,Logo,3,LoL,1,London,2,London 2012 Olympics,5,London Has Fallen,1,Lords Cricket Ground,1,LTE,4,LTE SIM,1,LTO,1,Lucy,1,Luma,1,Lumia,1,Lyrics,1,Mac,2,Mac OS,1,Machine,2,Mainstream,2,Make,1,make money online,11,Malaysia,2,Malicious Software,1,Malware,5,Manga,2,Manila,1,Manila Major,1,Manny Pacquiao VS Manuel Marquez 4,1,Marketing,10,Marketing Plan,1,Mars,1,Marvel,13,Marvel Cinematic Universe,1,Marvel Studios,7,Matt Damon,1,May Election 2013,1,Meme,2,Mercedes-benz,1,Message,1,MH370,1,Mi 8,1,Mi5,1,MicroSD Card,1,Microsoft,25,Microsoft Excel,2,Microsoft Mobile,1,Microsoft Office,4,Microsoft One Drive,1,Microsoft Windows,3,Microsoft Word,2,Miley Cyrus,1,Mind-Blown,1,Minecraft,1,Misc,21,Miss,1,Miss Universe,1,Miss Universe 2017,1,MLM,4,MOBA,2,Mobile,33,Mobile Broadband,1,Mobile Legends Bang Bang,1,Mobile Prepaid,1,Mobile Trick,2,Mobile World Congress,3,Mobile World Congress 2012,1,Modem Tricks,14,Monetize,4,Moon Landing,1,Mother's Day,3,Motherboard,2,Mouse,1,Movie,46,Movie Review,6,Movie Sequel,4,Movie Teaser,2,Movie Trailer,22,Mozilla,2,Mozilla Firefox,3,MS-DOS,1,MSI,2,Mult-Media,2,Multimedia,11,Multiplayer,2,Music,2,Music Video,2,Muslim Holiday,3,MyGlobeConnect,1,MyPhone,15,MyPhone Agua Series,3,MyPhone Ocean,1,MyPhone Ocean Elite,1,MyPhone Ocean Pro,1,MyPhone RIO,1,MyReward,1,MySQL,1,Mystery,1,MySuperPlan,1,Myths,1,Namecheap,3,Napolcom,1,NASA,8,National,1,National Day,1,NBA,1,NBI,1,NCLEX,1,Nestle,1,Netbook,4,Netflix,3,Network,6,Network Connection,1,Network Prefix,1,Networking,4,Neuro,2,News,193,Nexus 5,1,Nike,2,Nikon,1,Ninoy Aquino Day,1,Nintendo,1,No Filter,1,Nobel Prize,1,Nokia,13,Nokia Lumia,1,Nokia X,1,Normandy,1,Norton,1,Note Pro,1,Notebook,3,NTC,1,nTrust,1,Nuffnang,7,NVIDIA,6,O,1,O+,1,Octacore,2,oDesk,1,Offers,1,Office 2016,1,OG,1,OLED,2,OLED TV,2,Olympic,1,One Touch,1,Online,5,Online Game,1,Online Job,6,Online Market,2,Online Payment,2,Online Photo Editor,1,online project scheduling software,1,Online Shop,1,ONSA,1,Open Platform,1,Opera,1,Operating System,6,Optimize Websites,2,Optus,1,Organization,1,Origin,1,Outer Space,1,Outlook,1,Pacquiao,1,PAGASA,2,Page Insights,1,Paluwagan,1,Pamaskong Promo,1,Paper,1,PC,5,PC Repairs,1,PDF,1,Pebble,1,Pebble Steel,1,People,5,performance,1,Permits,1,Personal,1,Peter Jackson,1,PH Government,20,Phablet,2,Philippine General Election,3,Philippine Movie,1,Philippines,26,Philips,1,Phishing,1,Phone,4,Photo Editing,6,Photo Manipulation,3,Photography,4,PHP Hosting,1,Pickup,1,Pinoy,1,Pinterest,2,Pixar,1,Place,1,Planets,1,Plans,1,Platform,1,player-versus-player battle royale game,1,PlayStation,1,PlayStore,1,PLDT,3,Plugins,9,Pocket,1,Pokemon Go,1,popup image viewer,1,Portable,1,Poster,2,Power Bank,1,Power Supply Units,1,PowerApp,1,Prank,1,PRC,1,Premium,2,Prepaid,1,Prequel,1,Press,20,Press Release,111,Printer,3,Processor,2,Proclamation,1,Product,1,Product Review,2,Productivity,7,Profile,1,Program,1,Programming,10,Project,2,Project ARA,1,project management,6,project management software,2,project management tools online,1,Project Phire,1,Project Tango,1,Projector,2,Promo,14,Promos,4,ProXPN,1,PSU,1,Psychiatrist,1,Puzzle Game,2,Pyramid Schemes,1,Qadabra,1,Qualcomm,1,QuickSupport,1,Quotes,1,RA,1,RA 10175,1,Race,1,Ragnarok,1,RAM,4,Razer,1,Recall,1,Recovery,2,Reddit,1,Redmi,1,Referral,1,Registry Editor,1,Reimagine,1,Reminder,1,Remote Access,2,Report,1,Report of Rating,1,Republic Act,1,Research,6,Responsive Layout,1,Review,153,Reviewer,3,Reviews,116,Reward,2,Riddle,1,Rig,1,RN Exam,1,robot,1,Robotics,1,ROG,1,Role-playing,1,RoR,1,Rover,1,Rovio,1,Rugged Series,1,Rumored,1,Safe Mode,1,Salary,1,SALE,3,Sales,3,SalesForce,1,Samsung,30,Samsung Camera,1,Samsung Champ,4,Samsung Galaxy,10,Samsung Galaxy F,1,Samsung Galaxy Note,1,Samsung Galaxy Pocket,2,Samsung Galaxy S5,3,Samsung Galaxy S7,1,Samsung Gear,1,Samsung Gear Fit,1,San Diego Comic Con 2019,3,SanDisk,4,Santa Claus,1,SAPPHIRE,1,Satellite,2,Save,1,Scam,82,Scandal,1,Schedule,1,Schools,1,Sci-Fi,3,Sci-Tech,1,Science,19,Scientific,1,Screensaver,1,Scribd,1,Script,28,Scripts,1,SD Card,1,SEA,1,SEA Games,1,Seagate,1,Search,1,Search Engine,1,Search Keywords,1,SEC Advisory,1,Secrets,1,Security,25,See Online,1,Seen,1,SeenZoned,1,Seminar,1,SEO,4,SEOClerks,1,Sequel,2,service,5,Set,1,Sharp,1,Shoes,2,Shop Site,1,Shortening URLs,1,Showbiz,1,Signal,1,SIM,1,Singer,1,SingTel Group,1,SIRI,1,Site,8,Site Builder,1,Skills,1,SkyDrive,1,Sleep Cycle,1,SlideShare,2,SLR,1,Smart,23,Smart 4G LTE,1,Smart Always On,1,Smart Broadband,2,Smart Buddy,1,Smart LTE,1,Smart Plan,1,smart postpaid,2,Smart Prepaid,6,Smart Promo,13,Smart TV,2,Smart Watch,1,Smartphone,100,Smartphones,2,Smartwatch,6,SMS,1,Snapchat,1,Sneak Peek,1,Sneaker,1,Social Media,3,Social network game,1,Software,105,Solution,6,Sony,7,Sony Pictures,1,Sony Xperia,5,Space,2,Spam,2,Spartan,2,Speaker,1,Special,1,Specification,17,Specs,58,Speed,5,Spider Man,1,Spider-Man,1,Spoilers,1,Sports,2,Spotify,3,Spyware,1,St. Nicolas,1,StableCoin,1,Standalone,1,Standards,1,Star Wars,1,StarCraft 2,1,Starmobile,1,Startbucks,1,Startup,5,Starwars,1,Steam,11,Step-by-step,1,Storage,8,Strange,1,Strategies,3,Stream Global Services,1,Study,4,Success Stories,2,Suggestion,1,Summer,1,Summer Scrub,1,Summit,1,SUN,1,Sun Cellular,13,Sun Postpaid,5,Sun Prepaid,3,Sun Promo,9,Sun Trio,1,SUNDROID,1,SUNTRAXX,1,SuperSurf promo,1,Support,1,Survey,1,Susan Bennett,1,SWA,1,SWA Ultimate,1,System,11,System Mechanic,6,System Tool,4,Tablet,16,Talk N Text,1,tampermonkey,1,TaskManager,1,Tattoo 4G Flash,1,TBP,1,team collaboration site,1,TeamViewer,1,Teaser,3,Tech Blog Awards,1,Techniques,1,Technology,66,Technopreneur,2,Techpreneur,1,Tekken,1,Tekken 7,1,Telecom,4,Television,1,Telkomsel,1,Templates,1,Tenoshare,1,Terms,1,Text,1,The Amazing Spider Man,1,The Globe Tower,1,The Hobbit,1,The Hobbit: Battle of the Five Armies,1,The International 9,1,The Joy of Tech,1,ThePirateBay,1,ThL,1,Thor,1,thoughts,1,Thriller,1,Ti,1,TI 9,1,Ti7,1,Tip,1,Tips,91,Title,1,TLD,1,TM,7,TM Promos,5,TNC,1,TNT,1,Tool,9,Tools,46,TOP,4,Torque,2,Torrent,8,Toshiba,1,Touch Games,1,Tournament,2,Toyota,1,Trailer,15,Training,1,Travel,1,Trending,2,Tricks,11,Trivia,1,Trojans,1,Tropical Storm,5,Troubleshoot,11,Truck,1,Tumblr,1,Tutorials,55,TV,3,TV Series,5,Tweaks,53,Twitch,1,Twitter,16,TXT,1,Typhoon,8,Typhoon Ruby,1,Ucweb,1,UI,1,UK,1,UltraSound,1,Universal Pictures,1,UnliSurf,1,Unwind,1,Updates,2,Upwork,1,US Government,1,USB,4,USB 3.0,1,USB flash drive,4,USB Modem,2,USB Security,1,USB Technology,1,Useful,1,Useful Website,4,userscript,1,Utility,7,Valve,4,Vb.net,1,VB2010,1,Vector Art,1,Viber,1,Victim,1,Video,9,Video Card,1,Video Game,1,Videography,1,Videos,2,Villain,1,Vine,1,violetmonkey,1,Viral,8,Viral video,3,Virus,1,Viruses,1,Visual Basic 6,5,Visual Effects,1,VoIP,1,Vote,1,VPN,13,Warcraft,3,Warner Bros,5,Waste Ink Pad,2,WD,9,WD Drives,7,Weather,1,Web,320,Web Design,1,Web Email,1,Web Hosting,1,Website,3,WeChat,1,Weebly,1,Week Posts,2,Weird,1,Western Digital,18,WhatsApp,1,Whiskey,1,Who Views Profile,1,Wi-fi Stick,1,Widgets,9,Wifi,3,Win P5000,1,Win32 EXE,1,Windows,37,Windows 10,5,Windows 10 Event,2,Windows 7,4,Windows 8,7,Windows 8.1 Preview,1,Windows Phone,3,Windows Task Manager,1,Winner,1,Wireless,1,Wireless Charging,2,Wireless LAN,2,Wires,1,Word,1,Work,2,Work In Abroad,2,World Cup 2014,1,World's,3,World's First,4,wrike,7,Writing,1,X-MEN,1,Xiaomi,5,Yahoo,3,Yahoo Messenger,2,YankoDesign,1,Yolanda,2,Youtube,12,Z1,1,Zack Snyder,1,Zodiac Sign,1,Zoraida,1,Zynga,1,
ltr
item
Mabzicle: HOW TO: Calculate Age and Sort Monthly for the Birthdays using Microsoft Excel
HOW TO: Calculate Age and Sort Monthly for the Birthdays using Microsoft Excel
Sort out a list of people from youngest to oldest and categorically arrange by month with the given birthdate using Microsoft Excel!
https://4.bp.blogspot.com/-90am75_RCks/W3E0VCzXbcI/AAAAAAAAhzA/utFMxPzB4jAtM_eCoCsFCaWlgdSFA3ykACLcBGAs/s1600/first%2Bheader%2Btitle%2Bon%2Bcell.png
https://4.bp.blogspot.com/-90am75_RCks/W3E0VCzXbcI/AAAAAAAAhzA/utFMxPzB4jAtM_eCoCsFCaWlgdSFA3ykACLcBGAs/s72-c/first%2Bheader%2Btitle%2Bon%2Bcell.png
Mabzicle
http://www.mabzicle.com/2018/08/how-to-calculate-age-and-sort-monthly-using-excel.html
http://www.mabzicle.com/
http://www.mabzicle.com/
http://www.mabzicle.com/2018/08/how-to-calculate-age-and-sort-monthly-using-excel.html
false
219040821802169216
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy