automatically updating a date
 

Hello
I have a template with a date in a cell. From that date, a lot of others
dates are going to be automatically calculated, my questions a
1-how can we have this initial date to automatically be today's date (ie
when we open the template) so that it calculates automatically all the dates
regardless when we use the template
2- how do you then automatically obtain from that initial date, a date which
corresponds to this initial date plus 4 weeks
Many thanks
Pascale

automatically updating a date
 

In the cell that contains the initial date, put the formula:

=TODAY()

If you want to add 4 weeks (28 days) onto this, then you can use this
formula:

=A1+28

assuming the date is in A1.

Hope this helps.

Pete

On Sep 16, 5:14*pm, Pascale wrote:
Hello
I have a template with a date in a cell. From that date, a lot of others
dates are going to be automatically calculated, my questions a
1-how can we have this initial date to automatically be today's date (ie
when we open the template) so that it calculates automatically all the dates
regardless when we use the template
2- how do you then automatically obtain from that initial date, a date which
corresponds to this initial date plus 4 weeks
Many thanks
Pascale