Converting serial number to years, months and days

		Microsoft Office Forums > Microsoft Excel > Excel
Converting serial number to years, months and days

FAQ

Thread Tools

Display Modes

02-13-2013, 10:55 PM

Catalin.B

Windows Vista Converting serial number to years, months and days

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Have you ever formatted a cell? Just format the cell as a date...
Or maybe you yant to extract the year, day, or month from that date: use Year, Day, or Month functions...

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I get auto-updated "number of days since specified date" on MS word?	terry795	Word	16	01-07-2016 04:33 PM
Increase serial number for every print	atomtm	Word	1	06-15-2012 05:39 AM
Serial Number Issue	rehan5001	Excel	1	06-08-2011 02:46 AM
Setting up recurring months to skip some months etc.	dwelch@ykfireprevention.c	Outlook	0	11-30-2010 10:15 AM
Help needed using the serial number date with sumifs - whole office is stumped	FraserKitchell	Excel	3	01-06-2010 12:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:26 AM.