Attend IT Blog

Attend IT Limited has been serving the Brentford area since 2003, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Using a Spreadsheet to Calculate Exact Age

Tip of the Week: Using a Spreadsheet to Calculate Exact Age

Both Microsoft Excel and Google Sheets offer a plethora of features to those who know how to use them, many of them with really niche applications to businesses. For instance, there is one function that allows you to easily calculate the time between the current date and a specified  day that, if applied properly, could easily provide businesses with some serious utility.

Let’s discuss how the =DATEDIF function works, and how it could help you keep track of assorted pieces of data.

What Does =DATEDIF Do?

Using the =DATEDIF function returns the span of time between two different dates. Let’s say that you wanted to figure out how long your employees had each been working for your business.

In either Excel or Sheets, all you have to do is list the start dates that each employee began working for your company, and then in the next column, insert the formula cited below. For clarity we’ll assume that your list of dates starts in cell B2. Therefore, you would type the following formula into C2:


This will give you the difference between the provided date in B1, and “TODAY,” the date you’re accessing the sheet, measured in years. You can also replace the “Y” for years with “M” for months or “D” for days. Extending the formula down will give you the results for the rest of your list. For example, this is what it would look like in Google Sheets:

Likewise, it should look something like this in Microsoft Excel:

Be warned, however: this function is somewhat simple to break, so while there are other options, we wouldn’t recommend diving too far into them.

That being said, this trick could potentially be applied to a wide assortment of data, helping you to track the age of projects, time since your last workplace accident…really, it all comes down to what you need to keep track of.

For instance, you could hypothetically use it to track how long it has been since your team had to call Attend IT Limited for assistance, which is a perk that our managed services clients get to enjoy whenever they need it. Find out more by giving us a call at 020 8626 4485.

Six Steps to a More Secure Business Network
Not Even Voicemails are Safe from Phishing

Mobile? Grab this Article!

Qr Code

Tag Cloud

Security Technology Business Computing Network Security Productivity Best Practices Cloud Tip of the Week Data Backup Managed IT Services Hackers Business IT Services Disaster Recovery communications Data Data Recovery IT Support Privacy VoIP Hosted Solutions Software Innovation Backup Mobile Devices Cybersecurity Malware Small Business Efficiency Business Continuity Saving Money Computer Phishing Hardware Internet Cloud Computing Outsourced IT Email Business Management Productivity Automation Collaboration Microsoft BDR User Tips Smartphones Information Technology Internet of Things IT Support Ransomware Smartphone Workplace Strategy Upgrade Server Covid-19 Workplace Tips Managed IT Artificial Intelligence Quick Tips Users Mobile Device Management Risk Management Meetings Budget Managed IT services Network Compliance Mobility Communication Managed Service Provider BYOD Mobile Device Training Save Money Remote Document Management Gadgets Networking Windows 7 Avoiding Downtime Human Resources Wi-Fi Google Remote Workers Passwords Spam Android Firewall Password Remote Work Information Windows 10 History Employee-Employer Relationship Content Filtering Instant Messaging VPN Printing Hosted Solution Virtual Private Network Data Management Wireless Microsoft Office Cost Management Remote Computing Router Project Management Chrome Time Management MSP Managed Service Computers Employer-Employee Relationship Redundancy Data Security Machine Learning Voice over Internet Protocol Tech Term Marketing Solid State Drive Recovery Business Technology Mobile Paperless Office Manufacturing Laptop Backup and Disaster Recovery Personal Information Mobile Office Encryption Video Conferencing Devices Wireless Internet Computing Social Media Managed Services Government Audit Telephony Telephone Systems Office Conferencing Big Data Software as a Service Hacker Help Desk Automobile IT Service Value Monitoring End of Support Hard Drives Maintenance Hybrid Cloud Saving Time Printer Printers Data Breach Dark Web Social Engineering Work/Life Balance Voiceover Internet Protocol Smart Tech Vendor Remote Working User Error Students Utility Computing Copier Advertising App Phone System Inventory Management Word Hacking Update Entertainment Samsung PCI DSS Financial Technology Application Infrastructure Unified Communications Office 365 Hiring/Firing Business Telephone Connectivity Disaster Data Loss Legal e-waste Fiber Optics WPA3 SaaS Managed IT Service Employer/Employee Relationships Azure Vulnerability Regulation Save Time Smart Technology Administration Blockchain Wasting Money OneNote HIPAA Regulations Compliance Professional Services Workers Troubleshooting Battery Two-factor Authentication Videoconferencing Remote Monitoring Nanotechnology Transportation RMM Smartwatch Computer Repair Streaming Media Data Protection Electronic Medical Records Leadership Wireless Technology Cybersecurty PDF Windows Server 2008 Proactive File Storage Virtualization Cost SMB Active Directory Colocation Break/Fix Lifestyle Window 10 Amazon Company Culture Going Paperless Travel Development Proactive IT Private Cloud AI Streaming Payroll Going Green Windows 11 Content Filter Mobile Computing Files Applications Money Downtime Outsource IT Employees Black Market Bandwidth Shadow IT Outsourcing Windows Server Spyware Gamification The Internet of Things Current Events Online Storage IoT Analysis Virtual Assistant Telephone Antivirus Vendor Management Commerce Bitcoin Microsoft Outlook E-Commerce File Sharing Flexibility Copiers Chromebook Upgrades iPhone Apple Customer Service Windows 10 Cybercrime Customer Relationship Management Alexa for Business Business Intelligence Browser Workstations intranet Holiday Cabling Operating System Evernote Management Education Cleaning Finance Facebook Payment Cards Voice Office Tips Sabotage Consultant Virtual Reality Telephone System Health Benchmarks Fraud Specifications eCommerce Mobile Security Organization Digital Signage eWaste Gmail Wasting Time Excel Internet Exlporer Employee Sports Managed Services Provider IT budget Television CrashOverride Environment HaaS Windows Server 2008 R2 Smart Devices Emails IT Solutions Worker Keyboard Shortcuts Computer Care Workstation PC Credit Cards HBO Miscellaneous Reviews Print Windows Edge Net Neutrality Work Sales Virus Identity Music Social Windows Ink Device Security PowerPoint Accessory Cortana Humor Facebook Privacy Workplace Strategies Display Webinar WIndows Server 2008 Unsupported Software Computer Accessories Telework FAQ Testing Touchscreen Database Search Google Docs Ciminal YouTube Retail Best Practice Data Privacy WiFi Data Storage Analytics SSD Google Maps Peripheral iOS Sync How To Identities Updates CRM Google Assistant Co-Managed Services IT solutions Patch Management Point of Sale Financial Root Cause Analysis Audits Adobe Server Maintenance Wireless Charging Inventory Camera IT Management Safety Biometrics How To Microsoft Excel Myths Identity Theft Authentication Apps Holidays Websites Hard Drive Unified Threat Management Screen Mirroring Google Drive Relocation Access Control 5G Legislation Settings Politics Charger Policy Print Management Law Enforcement Tablets Microsoft Word Keyboard Twitter Windows 10s Outlook Computer Tips Bring Your Own Device Augmented Reality Solutions Supply Chain Investment WannaCry Communitications Projects 2FA Alert Managing Stress Emergency Threats Worker Commute Scam Internet Service Provider Windows 8.1 Text Messaging OneDrive Gifts Data Theft Cast USB Books Innovations Remote Management Security Cameras Video Games Processor Tech Support Memory Admin Computer Fan Medical IT Comparison Language App store Business Strategy Experience Procedure Healthcare Reputation NFL Micrsosoft Computer Forensics Hyperlink Hard Disk Drive Shortcut Scalability Scams Robot Licensing ROI Hosted Desktop Virtual Desktop Storage