Hi,
I am trying to get my excel sheet to tell me what quarter the dates are in,
for example What quarter.xlsx
Column A shows the date (yyyymm)
Column B shows the hours worked
Column C shows what quarter of hte year its in
so i want
d1 to equal 1 because its in the 1st quarter of the year
d6 to return 2
d13 to return 4 etc etc
Bookmarks