<div>
I would use this simple formula<br />
<br />
=VALUE(LEFT(A1,10))+1<br />
<br />
and custom format the cell to &quot;yyyy-mm-dd&quot;<br />
<br />
Sid
</div>


I would use this simple formula

=VALUE(LEFT(A1,10))+1

and custom format the cell to "yyyy-mm-dd"

Sid

<div>
Or this, in case I do not want to manually format the cell.<br />
<br />
=TEXT(VALUE(LEFT(A1,10))+1<wbr />,&quot;yyyy-mm-<wbr />dd&quot;)<br />
<br />
Sid<br />
<br />
BTW I am assuming that Cell A1 contains 2011-04-02T19:23:45.000Z
</div>


Or this, in case I do not want to manually format the cell.

=TEXT(VALUE(LEFT(A1,10))+1,"yyyy-mm-dd")

Sid

BTW I am assuming that Cell A1 contains 2011-04-02T19:23:45.000Z

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Iin a cell I've a date format like that:<br />
2011-04-02T19:23:45.000Z<br />
<br />
Now I like to add some days to it ...<br />
<br />
What is the right way to do so?<br />
<br />
Thanks<br />
<br />
Andre
</div>
</div>


Hi,

Iin a cell I've a date format like that:
2011-04-02T19:23:45.000Z

Now I like to add some days to it ...

What is the right way to do so?

Thanks

Andre

Add Days to a date using Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.