Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am seeking to gain a better understanding of constructing formulats using
dates and time. a) In the formula below I enter the start date in Cell A2 b) Number of weeks in B2 C) +/- days offset in C2 =DATE(YEAR(A2),MONTH(A2),DAY(A2)+7*B2+C2) Question 1 How do I modify the above formula to count in months instead of weeks? Question 2 Is it possible to adapt it so I can choose the period to count in: For example: Years, Months, Weeks, Days, Hours, Seconds Any examples would be appreciated Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Any more advice than the Excel help, on the XIRR Function? | Excel Worksheet Functions | |||
Advice on Creating an Excel Formula or Macro - PLEASE HELP!!!! | Excel Worksheet Functions | |||
Excel Application Development Costs - Need Advice | Excel Discussion (Misc queries) | |||
Almost got it !! but need advice | Excel Worksheet Functions | |||
need an advice in excel sheets.... | Excel Discussion (Misc queries) |