Results 1 to 6 of 6

date opbject??

Threaded View

  1. #1
    Registered User
    Join Date
    01-27-2006
    Posts
    3

    date opbject??

    Hi,

    When i place an date in the C colum the number in the B colum is added by 1.
    What i realy want is that the number start over again with 1 when i put in the next month.

    Like 1 to 20 inputs for the month januari en when februari comes Nr. starts over again with 1.

    Here is an screenshot of the situation:

    http://www.wens.speedxs.nl/excel.gif
    I am dutch so "ALS" means "IF" in the formula: =ALS(C4="";"";ALS(B3="Nr.";1;B3+1))

    Thanks in advance.
    Last edited by shailend; 01-27-2006 at 08:16 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1