WeekdayAdd - Dates | QuickBase Resources

Formula Function Reference

Our Formula Function Reference

Arguments:

(Date d, Number n)

Result Type:

Date

Explanation:

Returns the date that is n weekdays past the given date d. n may be negative to move backward in time.

Example:

WeekdayAdd([Start], [Duration]) returns the date that results if you add the value in the Duration field to the date in the Start field and count only weekdays. WeekdayAdd(ToDate("6/20/2003"), 2) returns 6/24/2003 WeekdayAdd(ToDate("6/24/2003"), -2) returns 6/20/2003 If you have a date field named "Start Date" and that field has a value of 6/23/2003, then WeekdayAdd([Start Date], -2) returns 6/20/2003

Tags:

formula

Comments

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <p> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <embed> <object> <param> <strike> <caption> <img> <h1> <h2> <h3> <h4>
You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>, <xml>. The supported tag styles are: <foo>, [foo].
Images can be added to this post.

Plain Text

Web page addresses and e-mail addresses turn into links automatically.
Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

Word verification: * Type the characters you see in this picture.

(verify using audio)

Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

Printer-friendly versionSend to friend

Formula Function Reference

WeekdayAdd - Dates

Comments

Post new comment

Similar Articles

Browse by Category

Knowledge Base Categories

Formula Category

Latest Community Forum Posts

The QuickBase Blog

Online Database Software:

Company Information:

Site Links:

From the Makers of: