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.
Syncfusion Feedback

Howto convert serial number of the date to date?

Thread ID:





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

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:


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)

tnx in advance

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


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



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

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?


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


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

Hi, I have found this alternative formula:


Is it correct?

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

Hi Stefano,

Thanks for your update.

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.



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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon