Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |