Formulae: Adding Time to Dates?

Valentina · June 18, 2014 3:49AM

Hi,

I have a Date column and a column showing the number of days ahead. Eventually I would like to get the Date ahead i.e. if the Date today is 10/06/2014 then in two days it will be 12/06/2014. Please see the example below.

[Date] [ DaystoAdd] [Date ahead]
10/06/2014 2 12/06/2014
04/06/2014 5 09/06/2014
30/05/2014 6 05/06/2014

Any ideas how to achieve this?

Thanks in advance

daniel · June 18, 2014 4:08AM

DATEADD(date, number, unit)

Use this function, replace the number bit with the column for days ahead and put "day" for unit.

paola · June 18, 2014 1:13PM

Thanks!
You could also create a dynamic formula, that calculates date which is n number of days from today:

DATEADD(TODAY(), [DaysToAdd])

DATEADD formula will assume "day" unit as default, so in this case you could skip that part of syntax.

Welcome!

Categories

Ideas Parade

Tagged