Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2015, 05:23 AM
gebobs gebobs is offline Timesheet autoformat problem Windows 7 64bit Timesheet autoformat problem Office 2010 64bit
Expert
Timesheet autoformat problem
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default 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?
Attached Files
File Type: xlsx Timesheet.xlsx (12.7 KB, 14 views)
Reply With Quote
  #2  
Old 02-24-2015, 06:03 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Timesheet autoformat problem Windows 7 64bit Timesheet autoformat problem Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 02-24-2015, 06:19 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Timesheet autoformat problem Windows 7 64bit Timesheet autoformat problem Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Change your CF to the following
Code:
=WEEKDAY($A2,2)=6
It's A2 that matters

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
Reply With Quote
  #4  
Old 02-24-2015, 06:34 AM
gebobs gebobs is offline Timesheet autoformat problem Windows 7 64bit Timesheet autoformat problem Office 2010 64bit
Expert
Timesheet autoformat problem
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Of jeez. I knew it was something stupid. Thanks, Peco.
Reply With Quote
  #5  
Old 02-24-2015, 06:43 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Timesheet autoformat problem Windows 7 64bit Timesheet autoformat problem Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Timesheet autoformat problem 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 autoformat problem Timesheet formula help beardking Excel 2 11-10-2009 02:06 AM
AutoFormat with style zac Word 0 01-12-2009 01:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:43 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft