Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 97 date diff
Hi there
I'm using Excel 97. No choice in the matter, the business is supposed to be upgrading in a few months. The spreadsheet is being used as a booking/scheduling system. Rooms being booked for days at a time. I've been reading through the archives on Google and some of the MVP links to see if I can solve a problem. Lots of interesting stuff, but I haven't found the answer yet. Basically I want to print the month name in the row above another row of dates. I only want to do this when the month changes. This formula does work up to a point: =IF(MONTH(E$2)-MONTH(D$2)0,TEXT(E$2,"MMM"),"") The problem is the text is truncated to column width. The cell is set up as general format. All cells are blank except those at the start of the month. I had expected the left cell's contents to be seen up to the point where was data in a cell to the right. I tried =IF(MONTH(E$2)-MONTH(D$2)0,TEXT(E$2,"MMM")) which evalutates to FALSE, but due to narrow cell width, they are displayed as # Any comments or thoughts? Thanks -ao- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Query Wizard Date Format | Excel Discussion (Misc queries) | |||
Excel file modification date | Excel Discussion (Misc queries) | |||
Excel formula with date constraints | Excel Discussion (Misc queries) | |||
In Excel 2003, entering date without slashes, the date is incorre. | Excel Discussion (Misc queries) |