#1
|
|||
|
|||
Timesheet autoformat problem
I have a timesheet and the user wants a line to visually differentiate between weeks. So I did an autoformat to add a border where weekday = 6 (i.e. Saturday).
Checking for February, it looks fine. But in March, it doesn't add a line between the last full week and the last partial. Any idea what gives? |
#2
|
||||
|
||||
I only see January on your example
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
||||
|
||||
Change your CF to the following
Code:
=WEEKDAY($A2,2)=6 EDIT : your initial CF uses A8 but applies to the range starting in row 2, so at each row A8 increases as usual and when reaching row 27 the formula looks for the value in A33 which is empty and returns a 7 as weekday. The following rows do the same. The CF thus never kicks in
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
Of jeez. I knew it was something stupid. Thanks, Peco.
|
#5
|
||||
|
||||
Yeah, that's why I found the answer
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Timesheet formula | IndCom | Excel | 12 | 05-27-2011 01:27 PM |
Autoformat postformatting levelled headings | bolpom | Word | 4 | 03-18-2011 12:52 AM |
Problems with Autoformat as you type | bolpom | Word | 8 | 03-17-2011 11:12 AM |
Timesheet formula help | beardking | Excel | 2 | 11-10-2009 02:06 AM |
AutoFormat with style | zac | Word | 0 | 01-12-2009 01:12 PM |