Date change

[milesryl]

Hi,

I have a cell to list when the next payment is due from a client.
would like the payment dates to automatically update after the origina
payment date is reached. Payments are due every two weeks. Th
'payment due' cell is G17. So if the first payment was due today, the
tomorrow G17 would display the date two weeks from today. Thanks fo
your help

 

[Dave Hawley]

Hi

Assuming you have a valid date in the cell use:

=G17+14

You will find some details on Date and Times in Excel on this page:
http://www.ozgrid.com/Excel/ExcelDateandTimes.htm

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Debra Dalgleish]

If you have a cell that contains the start date for payments (e.g. G10)
and a cell that contains the number of days between payments (e.g. G12),
you can use the following formula in cell G17:

=G10+ROUND((TODAY()-G10)/G12,0)*G12

 

[JE McGimpsey]

Don't think this works - the OP wanted G17 to display the date 2 weeks
from the payment due date. This also wouldn't "automatically update
after the original payment date is reached."

Seems to me that (assuming G16 is the original payment date),

G17: =G16+CEILING(MAX(0,TODAY()-G16),14)

would work.