Hello
Hope you guys can help me settle this problem.
A = start date
B = end date
C = count the number of days that fall within 2010
D = count the number of days that fall within 2011
E = count the number of days that fall within 2012
Please see attached data for further info.
Also, I don't know if Excel will account for the fact that 2012 is a leap year.
Thanks
In c2
=MAX(0,MIN(DATE(C$1,12,31),$B2)-MAX(DATE(C$1,1,1),$A2)+1)
Copy down and across
Life's a spreadsheet, Excel!
Say thanks, Click *
hi thed85. it's good that you uploaded an excel file. but i'm having some problems with downloading some files here, so i'm going to make some assumptions.
A2 contains Start Date
B2 contains End Date
C1 contains 2010, D1 2011, E1 2012
so in C2,
=MIN(DATE(C$1+1,1,1),$B2)-MAX(DATE(C$1,1,1),$A2)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi
See solution attached.
Good luck.
Tony
Thanks Ace_XL. Your function also allows for leap year. Thats what i needed. Rep added!
benishiryo:
Thanks for the reply. Your function produces negative numbers. Can't see why?
ARGK:
Something seems to have gonw wrong. Your function only counts for a single year?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks