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

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top