how can I find last day of cell with a value?

[Harry0]

how can I find last day of cell with a value?
1st row has dates of every week for over a year
2nd row has random logs which some weeks are empty.

How can I find the last day info logged into row 2?

also to be able to find the value in a cell with a $ amount.

Thanks
example attached

 

[Monty]

Hello Harry0

Please find attatched...done for the date and amount...can be replicated to other..Let me know if you need anything...Happy to help you.

 

[bosco_yip]

Try,

1] The 1st day of cell with a value, in A2 enter formula :

=INDEX(D1:HA1,MATCH(1=1,INDEX(D2:HA2>0,0),0))

2] The last day of cell with a value, in B2 enter formula :

=LOOKUP(9^9,2:2,1:1)

Regards
Bosco

 

[Harry0]

Thanks the formula "
=IFERROR(LOOKUP(9^9,AB3:HY3,AB$1:HY$1),"0")" worked

Another issue now is the first day results it now working. odd
Any suggestions
Thanks