|
| Changing dates |
 |
Thu, 5 Jul 2007 22:15:03 -0500 |
How do you change dates from one year to the next in the same column, without
retyping them.?
Hutch309 |
| Post Reply
|
| Re: Changing dates |
 |
Thu, 05 Jul 2007 22:19:27 -060 |
hutch309.2 wrote:
> How do you change dates from one year to the next in the same column,
> without retyping them.?
>
> Hutch309
.... ?!? ... You need to explain a little better exactly what you mean.
In principle, you can change any date from one year to the next with @AMNTHS.
For example, today's date in one year from now will be @AMNTHS(@TODAY,12).
Cheers,
Uli
|
| Post Reply
|
| Re: Changing dates |
 |
Fri, 06 Jul 2007 13:58:38 +010 |
Hutch309.2:
> How do you change dates from one year to the next in the same
> column, without retyping them.?
>
Sounds like a job for a macro.
But Uli's right:
>
..... ?!? ... You need to explain a little better exactly what
you mean.
--
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)
|
| Post Reply
|
|
|
|
|
|
|
|
|
|