Hello good people,
I have been trying this from many days now, but I'm not able to achieve the results.
So basically, I need to calculate age for each date, as in if there's a gap in between the dates the age will start again from 1. I'm attaching an excel below. Please suggest me something helpful.
Hi @Anju Nair
"Namaskaram" 😊 ! Here is one solution using a Table Calculation that
gives you a recursive formula using PREVIOUS_VALUE after verifying that
the current and previous row are consecutive (their difference = 1).
I have attached the twbx file below. Let me know if you have any questions.
Hope this was helpful, not too difficult to follow and correctly answered your
question. If "Yes" then please "Upvote" this solution and "Select as Best"
to close this thread. That way others with a similar problem will have access
to this solution. Take care and best wishes !
Sincerely,
Soumitra
