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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top