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     www.energyefficientbuild.com.   Jun 15, 2013
user Pedro Barbosa (http://productforums.google.com/forum/?zx=z4upfbz66ash#!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!

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

Here's the link: https://docs.google.com/spreadsheet/ccc?key=0AiHp-LgTWTEhdDZlcXlYZEJ2THk5OE85UjFWQk1xenc&usp=sharing

Maybe the formula needs some improvement.

Thank you Yogi!
Pedro
---------------------------------------------------------------------------------------------------------------------------------------