Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / November 2006

Tip: Looking for answers? Try searching our database.

Days from.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ozhog - 15 Nov 2006 03:30 GMT
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 - 15 Nov 2006 03:44 GMT
> 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

Signature

(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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.