Calculate next date in series of dates

**led_blunt** · 09-24-2009, 11:52 AM

I have a spreadsheet that lists items in column A with a start date in column B. What I need to do is in in column C list the next review date in increments of 5 days, but I only want the next day to show from the current date, not the inputted start date.

For example:

Column A Column B Column C
Item Start Date Next Review Date
Item A 12-Sept-09 27-Sep-09

Can I get a formula to calculate the increments and only show the next calendar date for the review, and then to change to the next date once the previous date has passed.

Alternatively, I have another sheet in my workbook that calculates the dates, is there some way I can display the next future date in a line of dates?

How I explained this properly, thanks

Matt

**shg** · 09-24-2009, 12:32 PM

=a1 + ceiling(today() - a1, 5)

**led_blunt** · 09-24-2009, 12:40 PM

Thanks SHG,

only thing is, when the start date is empty the formula shows todays date by default, can I get that to be blank if no date is entered?

Thanks,

Matt

**shg** · 09-24-2009, 01:16 PM

=if(a1="", "", a1 + ceiling(today() - a1, 5) )

**led_blunt** · 09-24-2009, 02:22 PM

Thank you,

Worked exactly as I wanted.

**shg** · 09-24-2009, 02:23 PM

You're welcome. Would you please mark the thread as Solved?

Calculate next date in series of dates

LinkBack

Thread Tools

Rate This Thread

Display

Calculate next date in series of dates

Re: Calculate next date in series of dates

Re: Calculate next date in series of dates

Re: Calculate next date in series of dates

Re: Calculate next date in series of dates

Re: Calculate next date in series of dates

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions