120+ Professional Project Management Templates!

Save Up to 85% LIMITED TIME OFFER

Date & Time Functions

Effectively Manage Your
Projects and Resources

With Our Professional and Premium Project Management Templates!

Built by PNRao — Trusted Since 2012

Analysistabs was created by PNRao, a project management professional with over 15 years of experience across finance, telecom, healthcare, and retail. What started as a personal Excel blog in 2012 has grown into a resource used by 50,000+ professionals worldwide. Every template is built from real-world project experience — not generic AI-generated content.

Free Templates

Premium Templates

Free project management templates and Excel automation guides by PNRao. Download professional templates for project planning, budgets, dashboards, timelines, and more. Compatible with Excel 365, 2024, and 2021. Trusted by 50,000+ professionals since 2012.

Date & Time Functions

VBA Date Function

VBA Time Function

VBA DateAdd Function

VBA DateDiff Function

VBA Day Function

VBA Second Function

VBA TimeSerial Function

VBA FileDateTime Function

VBA DatePart Function

VBA TimeValue Function

VBA Now Function

VBA DateSerial Function

VBA Hour Function

VBA Month Function

VBA WeekdayName Function

VBA Year Function

VBA DateValue Function

VBA FormatDateTime Function

VBA Minute Function

VBA MonthName Function

VBA Timer Function

VBA Weekday Function

Built by PNRao — Trusted Since 2012