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,