| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
chose days by month
I would like to write a function that is different for each month. My dates
are written in dd/mm/yy format. i am looking for a way to reference the specific cells in a month without referencing day by day. For example i would write an IF statement like =IF(A1=(SOME DAY IN MARCH?),A1,"". Can anyone help? I am familiar with arrays and most functions i am just unsure of what to use. Thanks A 1 3/3/2006 2 4/4/2006 3 3/16/2006 4 5/2/2006 5 4/29/2006 6 2/2/2006 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
chose days by month
One way:
=IF(MONTH(A1)=3,A1,"") In article , Dave wrote: I would like to write a function that is different for each month. My dates are written in dd/mm/yy format. i am looking for a way to reference the specific cells in a month without referencing day by day. For example i would write an IF statement like =IF(A1=(SOME DAY IN MARCH?),A1,"". Can anyone help? I am familiar with arrays and most functions i am just unsure of what to use. Thanks A 1 3/3/2006 2 4/4/2006 3 3/16/2006 4 5/2/2006 5 4/29/2006 6 2/2/2006 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Days per month for calculating storage days | Excel Worksheet Functions | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| Dates - Several Days In a month to month only | Excel Discussion (Misc queries) | |||
| How to Set a fix # of days per month | Excel Worksheet Functions | |||
Hybrid Mode
