Excel Extracting from serial date format in Excel

C

Chuck D

Joined
Nov 23, 2007
Messages
28
Reaction score
2
I am trying to use data such as Day and Month as Values,
I have a serial date value and although I can format this to mm or dd and get the desired number, this cannot be used for further calculations because when called i get the whole serial value

ie: .date is 22/11/2009, Serial date i: 40139
if I format month as Date; mm the numbers appear as 11
if I format day as Date;dd the numbers appear as 22 as expected,
if I try to recall value of a cell I get 40139 for both instances....

Anyone got an answer? or know how to dissect serial date to get Years, Months and days as individual values

enjoy the brain teaser and thanks to all who try find the answer
 
OK. Put date either serial or date format in a cell, for instance (A1)
then where required put: =DAY(A1) and the result will be the day assigned to 40139 ie 22 if formatted as a number or Sunday if formatted dddd
the same for month, ie =MONTH(A1) the result vill be 11, or Nov, or November depending on how you format the cell..

Thanks again Chuck, Keep working on your other problems.......
 
Back
Top