Join dates with custom format and calculate age

		Microsoft Office Forums > Microsoft Excel > Excel
Join dates with custom format and calculate age

04-04-2020, 03:52 PM

Marcia

Windows 7 32bit Join dates with custom format and calculate age

Office 2013

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

Bob, the result of the joined date in the birthday column was 9/9/25 even if I selected the date format as dd//mm/yyyy.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Default How to automatically Calculate number of days between two dates?	wcngu1	Word	6	10-24-2019 04:20 AM
Calculate time over two dates	Diver	Excel	3	07-22-2017 11:31 PM
Is this possible? - Calculate and Display the date range between 2 specific dates	Premier-UK	Excel	2	08-18-2014 05:43 AM
IF Formula to calculate dates	Sophie1	Excel	2	04-23-2014 07:19 AM
How to change number format of dates	ketanco	Project	1	09-11-2012 02:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:44 PM.