| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Putting the Quarter on the page
How can I have my worksheet automatically update which Quarter it is?
-- Nicki Taylor |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Putting the Quarter on the page
=IF(MONTH(A1)<4,"1st Quarter",IF(MONTH(A1)<7,"2nd
Quarter",IF(MONTH(A1)<10,"3rd Quarter",IF(MONTH(A1)<13,"4th Quarter","")))) all on one line, watch out for email wordwrap........... Vaya con Dios, Chuck, CABGx3 "NTaylor" wrote: How can I have my worksheet automatically update which Quarter it is? -- Nicki Taylor |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Putting the Quarter on the page
If it's only calendar quarters, this is shorter
=INT((MONTH(TODAY())+2)/3)&"th Quarter" -- Regards, Peo Sjoblom "CLR" wrote in message ... =IF(MONTH(A1)<4,"1st Quarter",IF(MONTH(A1)<7,"2nd Quarter",IF(MONTH(A1)<10,"3rd Quarter",IF(MONTH(A1)<13,"4th Quarter","")))) all on one line, watch out for email wordwrap........... Vaya con Dios, Chuck, CABGx3 "NTaylor" wrote: How can I have my worksheet automatically update which Quarter it is? -- Nicki Taylor |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Putting the Quarter on the page
Thanks!
-- Nicki Taylor "CLR" wrote: =IF(MONTH(A1)<4,"1st Quarter",IF(MONTH(A1)<7,"2nd Quarter",IF(MONTH(A1)<10,"3rd Quarter",IF(MONTH(A1)<13,"4th Quarter","")))) all on one line, watch out for email wordwrap........... Vaya con Dios, Chuck, CABGx3 "NTaylor" wrote: How can I have my worksheet automatically update which Quarter it is? -- Nicki Taylor |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Page Numbering | Excel Discussion (Misc queries) | |||
| Page Numbers | Excel Discussion (Misc queries) | |||
| Can't delete a page break | Excel Discussion (Misc queries) | |||
| putting an excel spreadsheet on a web page | Excel Discussion (Misc queries) | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
Linear Mode
