Search:

Type: Posts; User: ExcelFanatic; Keyword(s):

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    165

    Re: Help with networkday formula

    Perfect! Thanks!!
  2. Replies
    3
    Views
    165

    Help with networkday formula

    Need some assistance. I have a spreadsheet that track available hours in a month using the NETWORK day function. My worksheet is setup as follows:

    HEADER ROW
    Column C: Hire Date
    Column D:...
  3. Replies
    7
    Views
    157

    Re: Percentage of month since start

    Thanks everyone. Your formulas helped me get my formula juices flowing. Since my spreadsheet has the firs day of the month from Aug 2013 - Dec 2017, I wanted to use that date in the calculation. It...
  4. Replies
    7
    Views
    157

    Percentage of month since start

    I am looking for a formula that will calculate the number of days from a start date to the end of the month and divide that by the length of the month to show a percentage.

    example: If the Start...
  5. Re: Calculate number of days used last week and this week to date between two dates

    Week is Sunday through Saturday
  6. Calculate number of days used last week and this week to date between two dates

    I use the following formula to calculate how many days were used last month
    ...
  7. Re: If statement to show complete, ongoing, next, and planned events

    <b>Excel 2012</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px"...
  8. Re: If statement to show complete, ongoing, next, and planned events

    <b>Excel 2012</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px"...
  9. Re: If statement to show complete, ongoing, next, and planned events

    I give up. Will start another post and see if I can figure it out
  10. Re: If statement to show complete, ongoing, next, and planned events

    =IF($C1="Ongoing","Next",IF($B2<TODAY(),"Complete",IF(AND($A2<TODAY(),$B2>TODAY()),"Ongoing","Planned")))
  11. Re: If statement to show complete, ongoing, next, and planned events

    Not sure why I cant post the formula. Any Ideas?
  12. Re: If statement to show complete, ongoing, next, and planned events

    IF($C2="Ongoing","Next",IF($B3<TODAY(),"Complete",IF(AND($A3<TODAY(),$B3>TODAY()),"Ongoing","Planned")))
  13. Re: If statement to show complete, ongoing, next, and planned events

    Not sure why I cant get the entire formula to post. It keeps removing part of it
  14. Re: If statement to show complete, ongoing, next, and planned events

    IF($C2="Ongoing", "Next", IF($B3<TODAY(), "Complete", IF(AND($A3<TODAY(),$B3>TODAY()), "Ongoing", "Planned")))
  15. Re: If statement to show complete, ongoing, next, and planned events

    IF($C2="Ongoing","Next",IF($B3<TODAY(),"Complete",IF(AND($A3<TODAY(),$B3>TODAY()),"Ongoing","Planned")))
  16. Re: If statement to show complete, ongoing, next, and planned events

    Keeps removing part of my formula when I post. Will try something else to show the whole formula
  17. Re: If statement to show complete, ongoing, next, and planned events

    The formula in my post is not complete (not sure how that happened). Here is my formula:
    ...
  18. If statement to show complete, ongoing, next, and planned events

    I have a worksheet showing events and have created a statement to show whether the event is complete, ongoing, next, or planned.
    ...
  19. Replies
    3
    Views
    13,441

    Office 2011 for Mac

    Does Easy-xl work with Office 2011 for Mac?
  20. Replies
    11
    Views
    704

    Re: Help with simple formula

    ?
  21. Replies
    1
    Views
    462

    Re: Counting days between 2 dates

    I figured out the formula for column F of the Cycle worksheet:
    =SUMIFS($G$2:$G$14,$A$2:$A$14,$A19,$C$2:$C$14,">="&$B19,$E$2:$E$14,"<="&$C19)

    However - now I need column G of the cycle worksheet...
  22. Replies
    1
    Views
    462

    Counting days between 2 dates

    I have 2 worksheets in my workbook. The first tracks events. The second is a summary sheet which shows cycle periods for my offices. I need column F in the summary sheet to sum column G of my event...
  23. Replies
    4
    Views
    305

    Re: Number of days between 2 dates

    Thanks for the help. reversing the order worked. Should have picked that out since it is a subtraction problem. I wasn't looking at my formula and seeing it.
  24. Replies
    4
    Views
    305

    Number of days between 2 dates

    In my spreadsheet columns L through O contain dates:
    L - Planned Start Date
    M - Actual Start Date
    N - Planned End Date
    O - Actual End Date

    In column Q I am looking for the number of days...
  25. Replies
    2
    Views
    375

    Re: concatenate dates

    Perfect - Thanks
Results 1 to 25 of 83
Page 1 of 4 1 2 3 4