| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.ssgi.nl/excel.gif I am dutch so "ALS" means "IF" in the formula: =ALS(C4="";"";ALS(B3="Nr.";1;B3+1)) Thanks in advance. -- shailend ------------------------------------------------------------------------ shailend's Profile: http://www.excelforum.com/member.php...o&userid=30916 View this thread: http://www.excelforum.com/showthread...hreadid=505924 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
| Another Date issue. | Excel Worksheet Functions | |||
| Date Math Problem | Excel Worksheet Functions | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Threaded Mode
