update values in a column everyweek by one

[waempix]

Hello . I don’t know if anyone could help me with this formula. Anyway let me explain. In E column I have column named preg.week . There are different values for each patient.I want excel update these numbers every week after i enter the value to E column. For example E3 column has value as 8 I want it be 9 next week and apply this formula for whole E column. I want to do this so i can follow which patient is closer to give a birth since it updates itself everyweek. Could you help me with this? Thank you.

 

[iggydarsa]

If you had a starting date in one of the columns (lets say column D), it would be easier to calculate:

=(TODAY()-D1)/7

 

[Joe4]

Cross-posted: update values in a column everyweek by one

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #10 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[waempix]

Cross-posted: update values in a column everyweek by one

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #10 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

I apologize for inconvience. I didnt know about this rule. It is an urgent matter if it is solved i will notify each forum. Thanx for the warning. I dont mean to waste anyone`s time. This excel file is to record patient`s progress. that is why it is important . I appreciate any help. Thank you

 

[waempix]

If you had a starting date in one of the columns (lets say column D), it would be easier to calculate:

=(TODAY()-D1)/7

Thank you ( tesekkurler) I got the solution now. Thanx for your effort.

Solution link:
update values in a column everyweek by one [SOLVED]