next date

  1. J

    Assign next date if current date has occurred more than 4x

    Hello! I am trying to do a scheduling formula wherein I have a block of cells which will become my start date. If I didn't have a constraint, the rows above these dates will simply be date+1. However, I can only schedule a maximum of 4 things on a given date. So, I need a formula that will...
  2. N

    Type in a date and it doesnt exist in database, Need to return the Next largest date

    So I am using a spreadsheet where on 'Page 1' I have a list of 10's of thousands of dates ranging from 2006 to now, (thousands because some days repeat), however there isn't a listing for Every date in that range. On 'Page 2' I have a form where I get the user to type in a date (In cell A1) in...
  3. L

    "Next Date" with known frequency and start date

    Help desperately needed. I don't think this should be too tough but for the life of me can't figure it out. I need a formula for Column C which will auto populate based on today's date Today(). Since we know the start date and the frequency, I just need to formula which gives me the next date...
  4. L

    Next Date in a series with known start date and frequency.

    Help desperately needed. I don't think this should be too tough but for the life of me can't figure it out. I need a formula for Column C which will auto populate based on today's date Today(). Since we know the start date and the frequency, I just need to formula which gives me the next date...
  5. S

    Conditional Formatting Next Date

    I am using Excel 2007. I have a spreadsheet that calculates in column F the next date a service is due. That next date is always the last day at 3, 6 or 12 months out from the date the area is serviced which is in Column E. What I would like to do is color code the cells in column F to show...
  6. S

    Next Date Macro

    I'm using Excel 2007. Hey is there a way to have a macro recognize the next date out from today? The dates I need the macro to look through would be distributed in a single column (F) comprised of about 74 rows. All the dates in that column are EOMONTH dates either 3, 6 or 12 months out...

Some videos you may like

This Week's Hot Topics

Top