+ Reply to Thread
Results 1 to 9 of 9

Days off formula based on last date of the month

  1. #1
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    256

    Days off formula based on last date of the month

    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

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Days off formula based on last date of the month

    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]

  3. #3
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    256

    Re: Days off formula based on last date of the month

    The workbook is attached.


    Thanks
    alam
    Attached Files Attached Files

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Days off formula based on last date of the month

    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.

  5. #5
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    256

    Re: Days off formula based on last date of the month

    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
    Attached Files Attached Files

  6. #6
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Days off formula based on last date of the month

    ..One more try..

    =DAY(EOMONTH(A2,0))-B2

  7. #7
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Days off formula based on last date of the month

    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

  8. #8
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Days off formula based on last date of the month

    Thank you Master. Just figured that may not always be the last day of the month in column A.

  9. #9
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    256

    Re: Days off formula based on last date of the month

    daddylonglegs / Fotis1991

    Both solution work fine for me thank you very much.



    alam

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1