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.
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.
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
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- LgTWTEhdDZlcXlYZEJ2THk5OE85UjF WQk1xenc&usp=sharing
Maybe the formula needs some improvement.
Here's the link: https://docs.google.com/
Maybe the formula needs some improvement.
Thank you Yogi!
Pedro
Pedro
---------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment