• I have created a excel spread sheet for logging submittals. I have titled a column “Actual date submitted”. I have another column titled “Number of days out” What I need to do is place a date or formula in the cells of the “Number of days out” column that each time I open up the spread sheet that all the cells in that column will up date to that days date, but left hidden. Then I want to take a row number go to that cell in the “Actual date submitted column” enter a date and move with in the same row to column titled “Number of days out” and have that cell reflect the number between the two dates. CAN YOU HELP!



    Have a great day & Thank you,


    :coolwink:

  • OK, I think I know where you're coming from.


    First - Create a "Name" using Menu: Insert|Names|Define


    Call the name Today


    In the "refers to" box, type =TODAY()


    OK - now you have a defined name in your workbook that will always return today's date....


    Now - let your "Number of days out" column be colB and your "Actual date submitted column" be colA (just for an eg).


    In say Cell B2 type the following formula
    =Today-A2 (make sure your colB formatted to 'number')


    Say your A2 cell is 01/03/2003 (1st March 2003), then using this formula, cell B2 will show the value 25. (i.e. 26 March - 1 March = 25 days).


    Hope this is what you were after. :beergrin:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!