Excel Made Easy

Formula converts date to quarter and year in Excel

A1 contains a date formatted cell as dd/mm/yr, say 01/15/06. What formula, in B1, would convert this date to: Q1-06?

Answer

use this formula if the date in cell A1  ="Q"&(ROUNDUP((MONTH(A1)/3),0)&"-"&RIGHT(YEAR(A1),2))

(for formulas, depending on your country, you might have to change ; with , or the opposite

You can find similar Excel Questions and Answer hereunder

1) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?

2) I am using Excel for Project Management - how can I find End Date for a task given Start Date and Task duration considering only working days?

3) How do I enter a formula in a cell using VBA (using Absolute Reference)?

4) One of my formulas has returned an error - how can I trace the error to fix it?

5) Applying a countif formula only to visible cells in a filtered list in Excel

6) Formula does not calculate in Excel

7) How do i apply a formula to an entire column in Excel

8) Sumifs with date range as criteria in Excel

9) I have a complex WorkSheet with lot of fields and data - How can I quickly find the cells that have formulas?

10) How do I enter a formula in a cell using VBA (using Relative Reference)?