Skip to main content
Question

Formula Field to Project Date Field

  • October 12, 2022
  • 0 replies
  • 25 views
Forum|alt.badge.img+2
Is it possible to create a way for when a number between 1-15 entered into a Numeric field could feed 1 plus day into a Date (summary) field?

------------------------------
Ricky
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22
    • MarkShnierYou
    • Quickbase Alumni
    • October 12, 2022
    I'm not quite sure what you mean, but if you want a new Formula Date field that takes a Date field and adds X days to it, the formula would be

    [Project Date] + Days([Days to Add])

    if you wanted those days to be Business Days  not counting weekends, then

    WeekDayAdd([Project Date], [Days to Add])

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement