View Single Post
  #1   Report Post  
GregR
 
Posts: n/a
Default 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