Forum Discussion

RickyWhite's avatar
RickyWhite
Qrew Member
2 years ago

Formula Field to Project Date Field

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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago
    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
    ------------------------------