Formula needed to find a date from a range of dates.

**belex** · 08-22-2011, 04:33 PM

Hi,
I wonder if anyone can help. I attach a spreadsheet with the problem. I think it's self-explanatory, but I need a formula that will return the date a subscription was paid.
Many thanks.

**NBVC** · 08-22-2011, 05:09 PM

Try:

=IF(SUM($B6:$F6),LOOKUP(9.9999E+307,$B6:$F6,$B$5:$F$5),"")

this looks for last number in the row and pulls the corresponding header. If there are no numbers, a blank is returned.

**belex** · 08-22-2011, 05:16 PM

That is fantastic - that works perfectly and was an amazingly quick and helpful reply.
Thanks so much!!

**Kiran9** · 08-22-2011, 05:20 PM

I'm assuming this is a question asked many times. I have followed various similar instructions but none of them seem to be able to carry out what I would like.

OK, I have to arrange some appointments on various day's and I would like to invite other attendees. Instead of sending a normal meeting invite to 20 people and having to receive 20 'accept/decline' emails, I would like them to download a file which will automatically sync with their excel and input it into their diary. Also, some of my attendees live in different time zones so can this sync with GMT?

I would really appreciate any help on this as I have been stuck for the last couple of days.

Thanks

**NBVC** · 08-23-2011, 07:42 AM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.