ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Days from. (https://www.excelbanter.com/excel-worksheet-functions/118833-days.html)

Ozhog

Days from.
 
If I have a date field in Column A, how do I set Column B to be Col.A+ a
certain number of days, where that number of days would be a figure set in
for example C1.

Sorry if this is simplistic, i'm a newbie.

Franz Verga

Days from.
 
Ozhog wrote:
If I have a date field in Column A, how do I set Column B to be
Col.A+ a certain number of days, where that number of days would be a
figure set in for example C1.

Sorry if this is simplistic, i'm a newbie.


If you have a date in A1 and a number of days in C1 and want in B1 a date
equal to A1 plus the number of days in C1, just input in B1 the formula:

=A1+C1



--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy




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

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