| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Timesheet Problem
I am trying to populate a timesheet with dates depending on the start date
in B2. If B2 is the 16th of the month of Sept, I don't want anything to show up on the calendar for the 31th (blank in other words). Here is the formula I am using, but not working. Help. TIA =IF(($B$2)="","31",IF(EOMONTH(B2,0)=TEXT(($B$2)+RO W()-14,"DDD dd"),"",TEXT(($B$2)+ROW()-14,"DDD dd"))) Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Links - Problem | Links and Linking in Excel | |||
| Problem with date base units for x axis | Charts and Charting in Excel | |||
| Hyperlink to word document problem | Links and Linking in Excel | |||
| Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
| File is locked for Editing by user problem | Excel Discussion (Misc queries) | |||
Threaded Mode
