LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default Calculate next number using dates?

Here's what I'm trying to do:
Using Excel's date serial numbers, create a unique value for every instance
of the same date in a column.

For instance, if there are two instances of the date 5/9/2004 in the same
column, then I want to display a value similar to this in the same row of a
different column: 38116.01 for one instance, and with the next instance
having this value: 38116.02. This value should increase incrementally by .01
every time a new instance of the same date is added to the column.

I hope this makes sense and that it's possible with a formula, not a macro.
Thanks in advance for your help!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculate number of days btw dates Nelson Excel Worksheet Functions 2 March 2nd 06 01:02 AM
Calculate number of months between 2 dates john liem New Users to Excel 4 June 1st 05 02:08 PM
Calculate number of months between 2 dates john liem New Users to Excel 0 June 1st 05 10:06 AM
HOW TO CALCULATE THE NUMBER OF YEARS BETWEEN TWO DATES RAMON Excel Worksheet Functions 2 February 21st 05 01:27 AM
HOW TO CALCULATE NUMBER OF WEEKS BETWEEN TWO GIVEN DATES(MAY BE . WARRENCHERYL Excel Worksheet Functions 1 January 5th 05 08:15 AM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"