Forum Discussion

RickyWhite's avatar
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?


1 Reply

  • 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)