We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.

# Howto convert serial number of the date to date?

#### Replies:

98437 Feb 28,2011 01:15 PM UTC Apr 18,2012 12:14 PM UTC ASP.NET Web Forms (Classic) 5
 Subscribe to this post Tags: Calculate
Claudio Vigasio
Asked On February 28, 2011 01:15 PM UTC

Hi,
how can i convert a serial number of the date to date in formula?

There are a lot of function will return the serial number:

Datevalue
Date
Time
Timevalue

but if i want add (for example) two days to the current day and i want return the result on date field what can i do?

FromSerialNumberDateToDate(TODAY( )+2)

Jisha Joy [Syncfusion]
Replied On March 1, 2011 06:34 AM UTC

Hi,

You could use the following code do calculation on the datetime value. Here the 2 has been added to the today's day value.

=DATE(Year(Today()),Month(Today()),DAY(Today())+2)

Regards,
Jisha

Claudio Vigasio
Replied On March 1, 2011 08:22 AM UTC

Hi,
the problem is that using the formula suggested by you can not take advantage of the automatic transmission of the month or year.

For example, if today was February 28, 2011 I would like to receive formula from March 2, 2011, or if it was December 31, 2010 I would get a return value equal to 2 January 2011.

The formula that inspired me back instead: "Year, Month, and Day parameters describe an un-representable DateTime."

What to do?

tnx

Jisha Joy [Syncfusion]
Replied On March 10, 2011 09:45 AM UTC

HI Claudio,

In Calculate Dates are stored as sequential serial numbers so that they can be used in calculations. By default, January 1, 1900 is serial number 1 and November 12, 2002 is serial number 37572 because it is 37572 days after January 1, 1900.

You can use the DAY, Month, Year functions to get the correcsponding values from the sequential serial numbers.

=DAY(DATE(Year(Today()),Month(Today()),DAY(Today())+2)) //returns the day

=Month(DATE(Year(Today()),Month(Today()),DAY(Today())+2)) //month

=Year(DATE(Year(Today()),Month(Today()),DAY(Today())+2)) //year

Regards,
Jisha

Claudio Vigasio
Replied On April 11, 2012 01:38 PM UTC

Hi, I have found this alternative formula:

TEXT(TODAY()+2,"dd/mm/yyyy")

Is it correct?

Mercy C [Syncfusion]
Replied On April 18, 2012 12:14 PM UTC

Hi Stefano,

You can make use of "FromSerialNumberDateToDate(TODAY( )+2)" to convert serial number to date. Also, try with USEDateinCalc property to usedates in calculation.

Please let me know if you have any concerns.

Regards,
Mercy.C

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.