Hello All,
I am looking for formula based on last date of the month . Suppose in in column A i have dates and column B i have running days i need to calculated the off days in column c Based on months?
Thanks
alam
Hello All,
I am looking for formula based on last date of the month . Suppose in in column A i have dates and column B i have running days i need to calculated the off days in column c Based on months?
Thanks
alam
Last edited by farrukh; 07-02-2012 at 07:12 AM. Reason: Running days
Hi Alam,
Not sure how running hours is related here.. are you talking about working hrs?
For last date of month, you can use EOMONTH function.. else help me understand your query, may be a sample workbook can explain better. thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
The workbook is attached.
Thanks
alam
Hi
Do you mean?
=NETWORKDAYS(A2,A2+B2)
Regards
Fotis.
-This is my Greek whisper to Europe.
--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.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Sorry i uploaded wrong now the workbook is reattached. I need the result in column C if in column A (1/31/2012) and in Column Running days are 15 then in column C the result would be 16 are off days?
Thanks and Regards,
Farrukh hameed
..One more try..
=DAY(EOMONTH(A2,0))-B2
That should do it, Fotis but if column A always contains the last day of the month anyway then it would be sufficient to use this version in C2
=DAY(A2)-B2
format C2 as general and copy down column
Audere est facere
Thank you Master. Just figured that may not always be the last day of the month in column A.
daddylonglegs / Fotis1991
Both solution work fine for me thank you very much.
alam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks