Automatically increment numbers (n+1) in column F when date has changed in column E

[PUYAG]

Greetings,

I am trying to create a spreadsheet where when anytime the date is getting updated, the OOS shows the previous value+1.

For instance, next time I edit the date to 5/21/2023, the OOS needs to be automatically updated to "6". 

Here is the sample sample:

      Column E        Column F

       Date                 OOS

       4/21/2022         5

Thanks

Puya

[#2]

@PUYAG 

You can enter a new date in a cell in range E2:E20 in the attached file. This might be what you want to do.

[#3]

@OliverScheurich
Thank you for your reply. The rows are fixed. Let's say next time they see symptom A for unit 12, They will change the previous date to the new date without adding a new row. if they don't see symptom B for unit 45 on that date, column F should remain unchanged for that symptom.

Column B Column D Column E Column F (oos)
Unit 12 Symptom A 5/21/2023 6
unit 45 Symptom B 3/21/2022 3

Thanks
Puya