find the last date in the month

[Nico Learning]

Hi All you Genius

I don't know if this is doable but i have an excel spread sheet where in column a i have the list of date and in row b:J i have some tasks

is there a way where i can find out the date of the last task with in a particular month?

e.g. if the month is October then i would like to see the date of the last task as 20/10/09 if thats the last date that i have to do a task

if this is not clear enough i can send an example to you via email if any of you are want

regards
Nick

 

[Domski]

Something like:

=MAX(IF(MONTH($A$1:$A$10)=MONTH(TODAY()),$A$1:$A$10))

Confirmed with Ctrl+Shift+Enter as it's an array formula.

Dom

 

[VoG]

Try

=DATE(YEAR(TODAY()),MONTH(TODAY())+1,0)