| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
display date based on condition
i wanted to display multiples of 5 for day in everymonth between the years
1999 to 2006.( 01-jan-1999,05-jan-1999......30-jan-1999,01-feb-1999,... ....30-feb-1999..............30-dec-2006) in excel columns help me on this |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
display date based on condition
Hmm... 01-jan-1999 doesn't seem to be a multiple of 5...and there is no
30-feb-1999 (or any other year). Perhaps: A1: 01-Jan-1999 A2: =A1+5-(DAY(A1)=1)-(DAY(A1+4)*(DAY(A1+4)<=4)) and copy down... In article , eesh wrote: i wanted to display multiples of 5 for day in everymonth between the years 1999 to 2006.( 01-jan-1999,05-jan-1999......30-jan-1999,01-feb-1999,... ...30-feb-1999..............30-dec-2006) in excel columns help me on this |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| Can I display various Graphic Files based on Condition? | Excel Discussion (Misc queries) | |||
| Excel: with an if condition display a row of cell if true | Excel Discussion (Misc queries) | |||
| Excel display on condition | Excel Discussion (Misc queries) | |||
| Display message based on condition | Excel Worksheet Functions | |||
Linear Mode
