Forum Discussion
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?
- MAngostoIron Contributor
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.