| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date To Quarter, Plus Next 3 Quarters
I need to create 4 text labels in the format of qQyy (as in 4Q06).
I can easily determine the current quarter using the formula: =ROUNDUP(MONTH(NOW())/3,0)&"Q"&RIGHT(YEAR(NOW()),2) =4Q06 but I'm having trouble coming up with a formula to calculate the next 3 Quarters (1Q07, 2Q07, 3Q07) using the current date as the starting point. I would greatly appreciate any help. Thanks. Bob |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date To Quarter, Plus Next 3 Quarters
Sorry, after I displayed my original post, I believe I have now come up with
the solution: =ROUNDUP(MONTH((NOW())+91)/3,0)&"Q"&RIGHT(YEAR(NOW()+91),2) =1Q07 =ROUNDUP(MONTH((NOW())+182)/3,0)&"Q"&RIGHT(YEAR(NOW()+182),2) =2Q07 =ROUNDUP(MONTH((NOW())+273)/3,0)&"Q"&RIGHT(YEAR(NOW()+273),2) =3Q07 "Bob" wrote: I need to create 4 text labels in the format of qQyy (as in 4Q06). I can easily determine the current quarter using the formula: =ROUNDUP(MONTH(NOW())/3,0)&"Q"&RIGHT(YEAR(NOW()),2) =4Q06 but I'm having trouble coming up with a formula to calculate the next 3 Quarters (1Q07, 2Q07, 3Q07) using the current date as the starting point. I would greatly appreciate any help. Thanks. Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| How to return a value between date ranges | Excel Worksheet Functions | |||
| Another Date issue. | Excel Worksheet Functions | |||
| Format to display date as Quarter | Excel Discussion (Misc queries) | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Linear Mode
