# Search:

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

Page 1 of 4 1

1. ## Thread: Help with networkday formula

by ExcelFanatic
Replies
3
Views
167

### Re: Help with networkday formula

Perfect! Thanks!!
2. ## Thread: Help with networkday formula

by ExcelFanatic
Replies
3
Views
167

### 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:

Column C: Hire Date
Column D:...
3. ## Thread: Percentage of month since start

by ExcelFanatic
Replies
7
Views
164

### 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. ## Thread: Percentage of month since start

by ExcelFanatic
Replies
7
Views
164

### 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. ## Thread: Calculate number of days used last week and this week to date between two dates

by ExcelFanatic
Replies
2
Views
294

### Re: Calculate number of days used last week and this week to date between two dates

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

by ExcelFanatic
Replies
2
Views
294

### 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. ## Thread: If statement to show complete, ongoing, next, and planned events

by ExcelFanatic
Replies
13
Views
564

### 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. ## Thread: If statement to show complete, ongoing, next, and planned events

by ExcelFanatic
Replies
13
Views
564

### 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. ## Thread: If statement to show complete, ongoing, next, and planned events

by ExcelFanatic
Replies
13
Views
564

### 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. ## Thread: If statement to show complete, ongoing, next, and planned events

by ExcelFanatic
Replies
13
Views
564

### 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. ## Thread: If statement to show complete, ongoing, next, and planned events

by ExcelFanatic
Replies
13
Views
564

### Re: If statement to show complete, ongoing, next, and planned events

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

by ExcelFanatic
Replies
13
Views
564

### 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. ## Thread: If statement to show complete, ongoing, next, and planned events

by ExcelFanatic
Replies
13
Views
564

### 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. ## Thread: If statement to show complete, ongoing, next, and planned events

by ExcelFanatic
Replies
13
Views
564

### 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. ## Thread: If statement to show complete, ongoing, next, and planned events

by ExcelFanatic
Replies
13
Views
564

### 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. ## Thread: If statement to show complete, ongoing, next, and planned events

by ExcelFanatic
Replies
13
Views
564

### 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. ## Thread: If statement to show complete, ongoing, next, and planned events

by ExcelFanatic
Replies
13
Views
564

### 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. ## Thread: If statement to show complete, ongoing, next, and planned events

by ExcelFanatic
Replies
13
Views
564

### 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. ## Thread: Office 2011 for Mac

by ExcelFanatic
Replies
3
Views
14,024

### Office 2011 for Mac

Does Easy-xl work with Office 2011 for Mac?
20. ## Thread: Help with simple formula

by ExcelFanatic
Replies
11
Views
712

?
21. ## Thread: Counting days between 2 dates

by ExcelFanatic
Replies
1
Views
469

### 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. ## Thread: Counting days between 2 dates

by ExcelFanatic
Replies
1
Views
469

### 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. ## Thread: Number of days between 2 dates

by ExcelFanatic
Replies
4
Views
306

### 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. ## Thread: Number of days between 2 dates

by ExcelFanatic
Replies
4
Views
306

### 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...