Prev: Sorting with sumif function
Next: Countif query
From: MAX on 15 Feb 2010 17:08
Hello
I need a formula that add 13 days to a given date.
Example of this is that I have a date in cell F10 (01/02/10) and I want cell
F11 to appear as (14/02/10).

Thanks in advance.
From: T. Valko on 15 Feb 2010 17:14
It's just simple addition...

Entered in F11:

=F10+13

--
Biff
Microsoft Excel MVP


"MAX" <MAX(a)discussions.microsoft.com> wrote in message
news:A8BFCBA1-A64E-4C62-8BE6-AC86E31ACE54(a)microsoft.com...
> Hello
> I need a formula that add 13 days to a given date.
> Example of this is that I have a date in cell F10 (01/02/10) and I want
> cell
> F11 to appear as (14/02/10).
>
> Thanks in advance.


From: Eva on 15 Feb 2010 17:19
it should't bee any problem - just add

=f10+13

Click yes if helped
--
Greatly appreciated
Eva


"MAX" wrote:

> Hello
> I need a formula that add 13 days to a given date.
> Example of this is that I have a date in cell F10 (01/02/10) and I want cell
> F11 to appear as (14/02/10).
>
> Thanks in advance.
 | 
Pages: 1
Prev: Sorting with sumif function
Next: Countif query