Formula to return a date

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to return a date

FAQ

Thread Tools

Display Modes

04-15-2015, 08:59 AM

Pecoflyer

Windows 7 64bit Formula to return a date

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

Just enter =A1 in the third column ( A being date of birth) and Custom format the cell as suggested

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HELP: Return a value with a date that falls between two other dates	hionman	Excel	5	11-12-2014 09:56 AM
MS Excel Investing Formula for calculating stock return HELP pls	doug6388	Excel	0	09-05-2014 08:48 PM
Excel Formula: return a range of cells that match	tinfanide	Excel	4	08-30-2014 07:03 AM
Formula to calculate Date and Time	funkyfido	Excel	2	06-25-2013 04:25 PM
Need a date formula	MPAVLAS	Excel	3	08-12-2010 10:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:12 AM.