| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
This did indeed help. Thank you very much for the quick responce.
swatsp0p wrote: This is possible if somewhere on your June 05 sheet you have a cell with the specified month in a date format. e.g. cell A1 could contain 38504 (the value for June 1, 2005) and format as mm/yy to show Jun 05. then this formula would work: =IF(MONTH(Sheet1!F4)=MONTH(A1),Sheet1!F4,"") adjust the name of Sheet1 to meet your needs HTH Bruce -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200509/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Excel Display Problem | Excel Discussion (Misc queries) | |||
| Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
| Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
| Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
Threaded Mode
