I have column A listing down trhe days of the month, short
date format. For day 29 to 31 I need and IF statement to
leave the cell Blank when the month changes/increases to
the next month.
I have column A listing down trhe days of the month, short
date format. For day 29 to 31 I need and IF statement to
leave the cell Blank when the month changes/increases to
the next month.
You need to install the analysis Toolpack (Tools -> Addins -> analysis
toolpack) Then you can use the EOMonth function... If you need more help than
that let me know...
HTH
"Dan" wrote:
> I have column A listing down trhe days of the month, short
> date format. For day 29 to 31 I need and IF statement to
> leave the cell Blank when the month changes/increases to
> the next month.
>
>
>
Jim,
Analysis toolpak is now loaded. A3 is the first date of
month and all date cells are formatted as ShortDate. I put
this formuls in cell A29 (and plan to filldown formula
down to A33):
=If(A30>EOMONTH(A3),"",A30+1)
but I get the error #N/A. Do I have to add some Format to
my formula? thanks, Dan
>-----Original Message-----
>You need to install the analysis Toolpack (Tools ->
Addins -> analysis
>toolpack) Then you can use the EOMonth function... If you
need more help than
>that let me know...
>
>HTH
>
>"Dan" wrote:
>
>> I have column A listing down trhe days of the month,
short
>> date format. For day 29 to 31 I need and IF statement
to
>> leave the cell Blank when the month changes/increases
to
>> the next month.
>>
>>
>>
>.
>
Try =IF(A30=EOMONTH(A30,0),"",A30+1)
"Dan" wrote:
> Jim,
> Analysis toolpak is now loaded. A3 is the first date of
> month and all date cells are formatted as ShortDate. I put
> this formuls in cell A29 (and plan to filldown formula
> down to A33):
> =If(A30>EOMONTH(A3),"",A30+1)
> but I get the error #N/A. Do I have to add some Format to
> my formula? thanks, Dan
>
>
> >-----Original Message-----
> >You need to install the analysis Toolpack (Tools ->
> Addins -> analysis
> >toolpack) Then you can use the EOMonth function... If you
> need more help than
> >that let me know...
> >
> >HTH
> >
> >"Dan" wrote:
> >
> >> I have column A listing down trhe days of the month,
> short
> >> date format. For day 29 to 31 I need and IF statement
> to
> >> leave the cell Blank when the month changes/increases
> to
> >> the next month.
> >>
> >>
> >>
> >.
> >
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks