|
Ok... I have a spreadsheet with an install date in column A. I have another date in column C (which represents the date of a service call). The dates in C are always after the date in A. If an install date is 4/10/2006, then I need all dates in column C that are up to 7/10/2006 to be Quarter 1, from 7/11/2006 to 10/11/2006 to be Quarter 2, and so on. Basically a quarterly calender year, but instead of Jan 1st being the start of a quarter, the install date in column A is representing the start of the year. Edit: And to complicate things, is there a way to simply go Q1-Q20 instead of resetting to Q1 after the fourth quarter? Eg. Column A Column C Column D (this is the column I need represented!) 4/10/2006 4/11/2006 Qtr 1 4/10/2006 4/15/2006 Qtr 1 4/10/2006 8/20/2007 Qtr 7 EDIT: NEVERMIND! =CEILING((DATEDIF(A1,C1,"m")+3)/3,1) (ok another forum got it for me but still i'm feeling pretty drat good at 230am) DFWlly fucked around with this message at 07:24 on Jun 12, 2009 |
# ¿ Jun 12, 2009 04:41 |
|
|
# ¿ Apr 27, 2024 23:54 |