Help requested for Excel Iteration problem

S

Sree

Hello, First time posting on this forum. Hope someone can clue me in
on how to do this-- I have been struggling for 2 days! I am wondering
if I need VB code (and have not done this before).

I am trying to have my workbook do the following:

Col. A has a service start date.
Col B needs to predict when a report is due.

Reports are due every 180 days. If (Col. A +180) is a future date,
this is easy. But if (Col. A +180) <TODAY(), I need to keep adding 180
to the cell until I get a future due date that is >TODAY().

Is there a way to do this? Thanks much!

Sree
 
O

Owen

I haven't tested this, but assuming the date you validating is in A1
this should work

=180*MAX(1,ROUNDUP((TODAY()-MIN(TODAY(),A1))/180,0))+A1
 
Top