Date ranges translate in to Periods and Quarters

[majidzahoor]

Hi Everyone,

I am newbie and same true for MS excel.
I am building up a tracker where I need a column to show corresponding Period and another column to show Corresponding column when the users add a date.
For example if a salesperson makes an appointment between 25/2/19-24/03/19, the period column should automatically populate it to 'P1' within these dates and any value entered for Feb, March, April should convert the quarter column to 'Q1' for these months. Please help. Thank you.

[sergiomabres]

Hi Maji
You could use the formula

Please Login or Register  to view this content.

in Q1 and give custom format "Q#"

MR2.jpg

Cheers
Sergio

[majidzahoor]

Hi Sergio, Thank you for your reply. Unfortunately, this formula did not work.

[KOKOSEK]

Could you attached any samples file (put some explanation in it and expected results examples), please?

[majidzahoor]

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.

[KOKOSEK]

It is not attachment, it pasted picture. Please attach. excel sample file.

[majidzahoor]

It is not attachment, it pasted picture. Please attach. excel sample file.

Sorry my machine bars me from uploads to this website.

[sergiomabres]

Where are 25/02/19 till 25/2/20 in you sheet in what cell?

[majidzahoor]

Actual Audit Date. It is column H on my sheet

[sergiomabres]

and the other date? Do you understand that Excel has to do a subtraction between 2 cells?

[majidzahoor]

Can I please email you this sheet

[majidzahoor]

Or I will upload it from my personal PC once at home. Thank you.