Hi KOKOSEK, Thank you for quick reply. Please see Excel Sample.PNG. I am making a tracker for the auditors around the World to fill up after they have done the audits. When they put the actual audit date, Period and Quarter column should populate automatically e.g. as 25/02/19 till 24/3/19 is P1 and Q1. For 12 months from 25/02/19 till 25/2/20 there are 12 Periods and four Quarters. Please help. Hope the picture uploads.