Skip to main content

Adjusting individual cell due date

  • March 16, 2018
  • 2 replies
  • 37 views
J

Hi folks. I have a column that uses the following formula to calculate a due date:

DATEADD({Pub Date},-91,‘days’)

Essentially, the first draft is due 91 days before the publication date.

However, sometimes I’ll need to adjust that date for an individual row. I thought I could solve that by adding a “Date Adjust” column. The norm value for the date adjust column would be zero, but I could add a positive or negative number in as needed to push the date either earlier or later.

I’m just trying to figure out what the formula should be. Any ideas on how to incorporate the {Date Adjust} column in with the DATEADD?

    This topic has been closed for replies.

    2 replies

    W
    Forum|alt.badge.img+5
    • W_Vann_Hall
    • Inspiring
    • March 17, 2018

    Try

    DATEADD(
    {Pub Date},
    IF(
        {Date Adjust},
        {Date Adjust}-91,
        -91
        ),
    'days'
    )

    That allows you to leave {Date Adjust} empty.

    J
    • Jill_Schoff
    • Author
    • New Participant
    • March 18, 2018

    Try

    DATEADD(
    {Pub Date},
    IF(
        {Date Adjust},
        {Date Adjust}-91,
        -91
        ),
    'days'
    )

    That allows you to leave {Date Adjust} empty.


    @W_Vann_Hall you are a lifesaver! Your formula worked PERFECTLY. Thanks so much!

    Terms & ConditionsAccessibility statement