How to add two weeks from today, as the default date for a List Column ?

Question

_{Tuesday, September 11, 2012 7:11 PM}

I have a date column, in a List. I need to default date to 2 weeks from today's date. 

There is no reference field to use Computed field.

All replies (4)

_{Tuesday, September 11, 2012 9:07 PM ✅Answered | 1 vote}

this is really simple. I found it..

From the Std. Column, (no Computed Col) set the default value as:-

=Today+14

voila !

Thanks,

_{Tuesday, September 11, 2012 8:05 PM}

I believe the correct formula for a Calculated Column would be something like:

[date column]+14

John

MCITP and MCTS: SharePoint, Virtualization, Project Server 2007
My books on Amazon: The SharePoint 2010 Disaster Recovery Guide and The SharePoint 2007 Disaster Recovery Guide.
My blog: My Central Admin.

_{Tuesday, September 11, 2012 8:20 PM}

if I have no ref. column will it work..?  

You said,

 [another date column] + 14

but what I am trying to do,

 [GateDate()] + 14 

any options..to default a date to 2 weeks from today..?

Thanks,

_{Sunday, January 27, 2019 7:42 PM}

I just tried this:

The correct syntax is=

Default Value   =Now()+14

Steven Schuyler SJS Enterprises www.sjsenterprises.co [email protected] Berkeley, CA USA