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


--
Sree
------------------------------------------------------------------------
Sree's Profile: http://www.excelforum.com/member.php...o&userid=35688
View this thread: http://www.excelforum.com/showthread...hreadid=554739

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


Sree wrote:
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


--
Sree
------------------------------------------------------------------------
Sree's Profile: http://www.excelforum.com/member.php...o&userid=35688
View this thread: http://www.excelforum.com/showthread...hreadid=554739

Works beautifully! Thank you so much Owen!


--
Sree
------------------------------------------------------------------------
Sree's Profile: http://www.excelforum.com/member.php...o&userid=35688
View this thread: http://www.excelforum.com/showthread...hreadid=554739