Formula for converting a date to quarter and leaving blank cell for no date values

Hello,

I am a new member to the forum and have been having trouble with a formula. I am using ="Q"&INT((MONTH(F3)/4)+1)&"-"&RIGHT(YEAR(F3),2) to convert a date in F3 to a quarter and year in J3. Is there a way to have J3 show an empty cell until the data is F3 is entered so it doesn't show Q1-00?

Attachment included.

Thank you,

JC

Try it this way:

=IF(F3="","","Q"&INT((MONTH(F3)/4)+1)&"-"&RIGHT(YEAR(F3),2))

Hope this helps.

Pete

Worked perfectly. Thank you for the quick response.

Hi there, This worked for me also (so thank you) however, how do you convert a date to a fiscal year quarter so that July to September is Q1, October to December is Q2, and so fourth.

By using the formula as written above, I am getting a Q3 results for an October date and I need it to return Q2 as the result.

Looking forward to any help I can get as I have spent a lot of time on this one and not having much luck I'm afraid.

It is all good - I worked it out finally...

IF(N25="","",(YEAR(DATE(YEAR(N25),MONTH(N25)-6,1))&"/"&YEAR(DATE(YEAR(N25),MONTH(N25)+6,1))))

The reason why I am trying to get this formula to work is because we have to report of the percentage of assessed grant applications that are approved for a particular formula as follows:

91 per cent of assessed applications have been approved for funding as at 30 September 2018.

Approved applications - 10
Not Approved applications - 1
Pending Applications - 20

So I have a master database that records all the dates (quarter and financial year) for when an application is submitted, and then I record when it is "Approved" and the approval date, "Not Approved" and the date, and then all the "Pending", so on a separate spreadsheet, I am populating all the data to give me the stats (as per above example) using COUNTIFS. This is to avoid trying to calculate the data / stats manually. Manually retrieving stats has caused many staff to get different stats to each other and I am trying to have it so that the data is automatically populated so there are no mistakes.