i am creating a template and only need it to report a quarter if there is a
date in the cell. how can I change this formula to report 0 if there is no
date?

"arno" wrote:

Hi,

let's assume you have a date in B2, then the following formula will
give you the quarter based on the month of that date:

=INT((MONTH(B2)-1)/3)+1

arno