Need help with formula for an auto updating column

I want to make a column with current issued dates that update automatically when ever a column to the right of it has a date added.

So for example lets say I have 3 columns and in the second column I add a date. That date would appear where I added it plus in the auto updating column to the left. Now if later I add a date to the third column it would update the first column and the second would remain unchanged.

I want to do this because I want to preserve a record of everytime I issue a drawing (this is for an architectural drawing set) while have one column that always shows the latest release for all drawings. Its the case that not all drawings would be issued together so there could end up being numerous issues resulting in a complicated matrix of dates and I think it would be good to have one column that shows only the current issue for each drawing.

If this is not clear I can probably upload a screen shot of my matrix.

Thank you

Originally Posted by Glenn Kennedy

Try:

=IF(B2="","",IF(C2="",B2,C2))

Originally Posted by WideBoyDixon

If you can continually publish drawings, you might need something like the attached.

WBD

Both of these post were extremely helpful and I was able to do what I wanted. Thank you