| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Down A formula advice......
I create this formula and copied it down.
=DATE(YEAR(B5), MONTH(B5)+1, DAY(B5)) I have custom formatted the date: mm/yy It works fine for most month sequences but when I enter an end of month date like 31/01/2005 and copy it down....February is missing... Mar-05 Apr-05 May-05 Can any one explain what I am overlooking? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Advice | Excel Worksheet Functions | |||
| Advice on Creating an Excel Formula or Macro - PLEASE HELP!!!! | Excel Worksheet Functions | |||
| need formula advice | Excel Worksheet Functions | |||
| Formula Advice Needed | Excel Discussion (Misc queries) | |||
| Almost got it !! but need advice | Excel Worksheet Functions | |||
Threaded Mode
