ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Date formula (https://www.excelbanter.com/excel-worksheet-functions/256346-date-formula.html)

Max

Date formula
 
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.

T. Valko

Date formula
 
It's just simple addition...

Entered in F11:

=F10+13

--
Biff
Microsoft Excel MVP


"MAX" wrote in message
...
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.




Eva

Date formula
 
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.



All times are GMT +1. The time now is 04:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com