View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] ribeiros@gmail.com is offline
external usenet poster
 
Posts: 1
Default Exel increment date problem wrt todays date.

A1=Name of person
B1=Date Joined club
C1=First Fee Due Date, =Bx+25, which is every 25th day from date
joined.
D1=Previous Fee Due Date
E1=Next Fee Due Date

I inserted D2, E2 and D3, E3 by finding out the dates by dragging Cx.

Question: How do I get D4 and E4 to display the dates with respect to
the current date? TODAY().

A1 B1 C1 D1 E1
Stephen 2/16/2007 3/13/2007 10/24/2007 11/18/2007
Larry 8/1/2007 8/26/2007 10/15/2007 11/9/2007
Peggy 9/6/2007 10/1/2007