Saturday, June 15, 2013

yogi_Compute Number Of Days In Month Of Column A Or B As Per Specified Rule

                                          Google Spreadsheet   Post  #1241
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jun 15, 2013
user Pedro Barbosa (!category-topic/docs/spreadsheets/NALxBcVodJo)
Counting days from the month after
Hello and excuse me for my English.

After many tries without success I'm here to ask for your help.

I'm trying to make a array formula that's able to count the next month days after the timestamp date. So, when I submit a new record on any day of July, it'll count how many days August have, and so on. I've already done a simple formula that seems to be able to do that... But I also need a form field where I can set a different date (only month and year) and then, when I write on it, it'll will count the days from the month following the month that was written.

Thanks for your help!

Hello Yogi!
When I was doing a spreadsheet to show you, I think I may have solved the problem!

Here's the link:

Maybe the formula needs some improvement.

Thank you Yogi!