how to now what date represent a serial number?

Guest · Apr 25, 2007

I'm working with the Workday() fomula, but the number i Received is a serial
number, I would like to change it to a date format

Guest · Apr 25, 2007

Try Formatting the cell as date instead of general.

Mike

Guest · Apr 25, 2007

Format >> Cells >> Number tab >> select Date >> OK

Guest · Apr 25, 2007

thank, I already did it was so simple!!!

Teethless mama said:
Format >> Cells >> Number tab >> select Date >> OK

Guest · Apr 25, 2007

thank to you, was really simple.

Mike H said:
Try Formatting the cell as date instead of general.

Mike

Add no. of days to a workday to get new workday?	1	Apr 15, 2010
Difference between NOW() and TODAY()	9	Feb 10, 2009
MATCH FUNCTION AND SERIAL DATE CONFLICTS	4	Oct 30, 2006
formatting a spreadsheet help	4	May 1, 2010
Calculate Future Date but don't want	6	Jul 22, 2009
Calculating new date by entering number of additional workdays	1	Apr 1, 2010
Workday Formula to include date	0	Aug 12, 2014
Formula for converting xx/xx/xxxx dates to a number between 1 and	2	Aug 20, 2009

Ask a Question