wjohnson1976
New Member
- Joined
- Aug 14, 2010
- Messages
- 11
Hello all,
I am trying to make an irrigation water demand worksheet for engineers and I am almost finished, but the date entry is perplexing me...
I want a user to be able to enter two dates then the days per month between the two populate a column as shown below. For example user enters "05/20/2010" and "09/14/2010"
Month Days
Jan 0
Feb 0
Mar 0
Apr 0
May 11
Jun 30
Jul 31
Aug 31
Sep 14
Oct 0
Nov 0
Dec 0
I tried using nested ifs with text and it was getting way out of hand for me. I realize the total number of days between can be easily displayed but the jump to separate months and let the other months=0 is out of my league!
Thanks in advance!
W. Johnson
I am trying to make an irrigation water demand worksheet for engineers and I am almost finished, but the date entry is perplexing me...
I want a user to be able to enter two dates then the days per month between the two populate a column as shown below. For example user enters "05/20/2010" and "09/14/2010"
Month Days
Jan 0
Feb 0
Mar 0
Apr 0
May 11
Jun 30
Jul 31
Aug 31
Sep 14
Oct 0
Nov 0
Dec 0
I tried using nested ifs with text and it was getting way out of hand for me. I realize the total number of days between can be easily displayed but the jump to separate months and let the other months=0 is out of my league!
Thanks in advance!
W. Johnson