Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CAn any one solve this problem of days months and years.its urgent plzzzzzzzzzzzz | Excel Discussion (Misc queries) | |||
No. of days split into periods | Excel Discussion (Misc queries) | |||
Calendar Days and Option Buttons | Excel Discussion (Misc queries) | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
Vacation Accrual Formula | Excel Worksheet Functions |