Hi
I have start and end Date.
Then columns for the end of eatch month.
I need to split in eatch month column, the dates for eatch month, that all together, make the difference..!!
I think it's better to take a look to the example.
Thank you in advance.
Last edited by Fotis1991; 02-14-2012 at 03:01 AM.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
See attached.
Formula In D2 copied down: =IF($A2<=D$1,MIN(D$1,$B2)-$A2,0)
Formula In E2 copied down and across: =IF($A2<=E$1,MIN(E$1,$B2)-$A2,0)-SUM(D2:$D2)
Dom
Last edited by Domski; 02-13-2012 at 10:36 AM.
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
PLS IGNORE BELOW FORMULA BCZ OF MISUNDERSTOOD!
In D2:
=D$1-IF(C$1="",$A2,IF(D1<=$B2,C$1,IF(C$1<$B2,$B2,D$1)))
Copy down and across
Last edited by bebo021999; 02-13-2012 at 10:36 AM.
Click the star icon in left-corner of my post if you find my post userful!
Quang PT
quangphanidico@yahoo.com
PM me: Y!M: quangphanidico
Value in J1 should be 31/7 than 30/7
Click the star icon in left-corner of my post if you find my post userful!
Quang PT
quangphanidico@yahoo.com
PM me: Y!M: quangphanidico
@ Dom.
Of course YES. This is it! Thank you. As i see, Today, it's your good day.
@bebo
Thank you.Value in J1 should be 31/7 than 30/7
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
My formula is a bit over complicated to be honest. bebo021999's would work fine.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Nooooop,
As I said pls ignore, it is wrong! Yours is simple and logical.
Click the star icon in left-corner of my post if you find my post userful!
Quang PT
quangphanidico@yahoo.com
PM me: Y!M: quangphanidico
To be honest, i saw this in post #3 and i did not look at bebo's formula at all!! Sorry for this!!
PLS IGNORE BELOW FORMULA BCZ OF MISUNDERSTOOD!
In D2:
=D$1-IF(C$1="",$A2,IF(D1<=$B2,C$1,IF(C$1<$B2,$B2,D$1)))
Copy down and across
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Fair enough. I thought it looked like it would work.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks