Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel calendar repeat event every 4 day (https://www.askmehelpdesk.com/showthread.php?t=464513)

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

    Thanks
  • Apr 13, 2010, 04:43 PM
    JBeaucaire

    Got a workbook to look at? I can't visualize what you're doing without it.
  • Apr 14, 2010, 01:39 AM
    Pajoooo
    1 Attachment(s)
    Try this,

    Thanks
  • Apr 14, 2010, 10:42 AM
    JBeaucaire

    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.
  • Apr 14, 2010, 02:59 PM
    Pajoooo
    1 Attachment(s)
    Sorry, my fault. Here's a file in xlsx format. Please help.

    Thanks
  • Apr 14, 2010, 03:03 PM
    JBeaucaire

    I don't use Excel 2007, sorry. I can read the files, but I can't make use of any of those new features.
  • Apr 16, 2010, 03:52 AM
    Pajoooo
    Quote:

    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.
  • Apr 16, 2010, 04:09 AM
    ScottGem

    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.
  • Apr 16, 2010, 12:38 PM
    JBeaucaire

    ... plus the two conditions he already has present.
  • Apr 19, 2010, 01:37 PM
    Pajoooo
    3 Attachment(s)
    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.

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