Forum Discussion

samanthakomene's avatar
samanthakomene
Copper Contributor
Apr 19, 2024

What formula do i use

I have a chart that I update daily and once I update the status as delivered in column G I have to put the current date in next to it in column H. is there any formula where when I change the status in column G it will automatically add in the current date in column H?

  • MAngosto's avatar
    MAngosto
    Iron Contributor

    samanthakomene 

     

    Hi!

    Use this in cells in column H:

     

    =IF(G3="Delivered",NOW(),"")

     

    Change G3 accordingly. You should format cells in column H to short/long date as desired.

     

    Note: You should take into account that the current date may change each day you open the workbook. That does not seem something you would want. You can fix that manually by pressing Control + ";" on each of these current dates to transform it into text... There are a couple of different ways to address this, including VBA code, but it maybe turns into something much more sophisticated for your desired functionality.

Resources