Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting
Within the budget worksheet for each month, I compare individual expense
against total expense to get a percentage. There are also two other cells that contain totals that each expense is compared against. I name those cells using the first three letters of each month: JULExp, JULNetInc, and JULGrInc. The upper-left cell of each budget has the date of the first day of each month entered, but the display is mmm-yy, ie Jul-08. I would like the formulas I use to pull the first three letters of the month from that date cell. EXAMPLE: A369 = 7/1/08 -- displayed as Jul-08 I373 = Expense Amount Formula in I374: I373 / JULExp Formula in I375: I373 / JULNetInc Formula in I376: I373 / JULGrInc Thanks, Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions |