Ask Experts Questions for FREE Help !
Ask
    Pajoooo's Avatar
    Pajoooo Posts: 60, Reputation: 1
    Junior Member
    		  
    #1

    Apr 13, 2010, 01:44 PM
    Excel calendar repeat event every 4 day
    I need formula to repeat event every 4 day in Excel calendar, starting 03.04.2010.

    Thanks
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Apr 13, 2010, 04:43 PM

    Got a workbook to look at? I can't visualize what you're doing without it.
    Pajoooo's Avatar
    Pajoooo Posts: 60, Reputation: 1
    Junior Member
    		  
    #3

    Apr 14, 2010, 01:39 AM
    Try this,

    Thanks
    Attached Files
  1. File Type: xls perpetual-calendar.xls (309.0 KB, 308 views)
    2. JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #4

    Apr 14, 2010, 10:42 AM

    In Excel 2003 you only get 3 conditional formatting rules. You would need 6 to pull this off.

    I don't use it, but in Excel 2007 I believe you can apply as many conditional formatting rules as you want.
    Pajoooo's Avatar
    Pajoooo Posts: 60, Reputation: 1
    Junior Member
    		  
    #5

    Apr 14, 2010, 02:59 PM
    Sorry, my fault. Here's a file in xlsx format. Please help.

    Thanks
    Attached Files
  2. File Type: zip perpetual-calendar.zip (87.5 KB, 120 views)
    3. JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #6

    Apr 14, 2010, 03:03 PM

    I don't use Excel 2007, sorry. I can read the files, but I can't make use of any of those new features.
    Pajoooo's Avatar
    Pajoooo Posts: 60, Reputation: 1
    Junior Member
    		  
    #7

    Apr 16, 2010, 03:52 AM
    In Excel 2003 you only get 3 conditional formatting rules. You would need 6 to pull this off.
    Which 6, show me, PLEASE, and I will add them in Excel 2007.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #8

    Apr 16, 2010, 04:09 AM

    I haven't tested this, but why not try taking the difference between the date in the cell and your start date. Then dividing by 4 and returning the MOD value. The result should be either 0,1,2 or 3. Then create 4 conditions for each value.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #9

    Apr 16, 2010, 12:38 PM

    ... plus the two conditions he already has present.
    Pajoooo's Avatar
    Pajoooo Posts: 60, Reputation: 1
    Junior Member
    		  
    #10

    Apr 19, 2010, 01:37 PM
    RESOLVED!

    For JBeaucaire,
    I don't know did you see all six conditions in EXcel 2003, and send them in another file.

    Thanks for the advice.
    Attached Files
  3. File Type: zip calendar.zip (87.0 KB, 87 views)
  4. File Type: xls calendar.xls (311.5 KB, 259 views)
  5. File Type: xls Conditional_Rules.xls (23.0 KB, 331 views)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Pressure goes to 60 and drops to 40, and repeat [ 3 Answers ]

My presssure goes to 60 and drops to 40 and then goes back to 60 and drops again. My relay and pump are obviously working fine, why would I be constantly losing pressure from my well.?

Can You Repeat Liposuction? [ 1 Answers ]

I had liposuction done on my thighs, but I am still not satisfied with the results and there still appears to be a lot of fat there. Can you have more lipo performed on the same area?

The repeat game [ 5 Answers ]

My oldest daughter is 3 yrs and7 months. my youngest daughter is 7 months. I believe the little one has something to do with the older ones attitude and behavior. I tell my 3yr old not to do something (like stand on hangers) and she does it anyway. I ask her " why did you just stand on those...

Does history repeat its self [ 86 Answers ]

Hey my ex and I split about a month ago. Ive only had no contact since aug.18 She got together with another guy a week later after breaking up. She claims she met him a week prior but who knows if that is the truth. We have been off and on. Im trying to move on but in a way I'm trying to move...

Why does history repeat with the following? [ 3 Answers ]

OK people I have witnessed some interesting behaviour on both sides of the sexes and I've lived through some of these situations on one side or the other but ultimately it's just left me wondering how different people answer some of these questions.. some of them are way way more heavily usually...

View more questions Search