| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difference between fixed and variable date
I have a date difference formula =DATEDIF(B1,TODAY(),"M") which works
fine. I thought I would amend the 'Today' bit of the formula to solve the problem where I want to know the number of months between a variable date and a fixed date. e.g. variable date Fixed Date Months Difference 15/06/2006 31/04/2007 ? 22/09/2006 31/04/2007 ? 03/02/2006 31/04/2007 ? Can you advise please. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How fill series containing one variable and one fixed value in XL | Excel Discussion (Misc queries) | |||
| Fixed column- Variable row # | Excel Discussion (Misc queries) | |||
| Variable column to fixed array | Excel Worksheet Functions | |||
| From a fixed cell to a variable | Excel Programming | |||
| Changing fixed date with a variable in a ODBC Query | Excel Programming | |||
Threaded Mode
