Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exel increment date problem wrt todays date.
What do your mean by "with respect to the current date"?
Do you mean how many days from today? If so use =your-formula - TODAY() and format as General best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email wrote in message ups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Todays date | Excel Discussion (Misc queries) | |||
Todays date | Excel Discussion (Misc queries) | |||
Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
How can I get an age using todays date and date of birth? | Excel Discussion (Misc queries) | |||
When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions |