Format a cell to give quarternumber from a date in Excell

G

Guest

Hi,
How do I format a cell in Excell to give me the quarternumber from a date?

Example: 2006-09-20 give quarternumber 3
 
G

Guest

Hi,

There isn't a standard format but quarter number can be derived
e.g. with date in a1, quarter number in b1 =ROUNDUP(MONTH(a1)/3,0)

Anthony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why isn't this returning the quarter number? 3
Excell 2021 0
How can I insert a callendar (point and click for date) in excell 2
/ key not displaying in cell 2
Excel is changing date format incorrectly 7
Month & Year Text to Date Format - Help Please 3
variable cell index 1
Calculate week from current day 6

Top