Re: counting number of days between anniversary day and payment due date
You are welcome.
Re: counting number of days between anniversary day and payment due date
You are welcome.
Re: Find Column Header Name for the Max in a Row
Coudl you post your workbook with example?
Re: counting number of days between anniversary day and payment due date
=$G$4-DATE(YEAR(D5),MONTH(E5),DAY(E5))
G4 is 31/07/2013
The answer is 1583 for the first line.
Otherwise Could you state the disired result?
Re: Find Column Header Name for the Max in a Row
forum.ozgrid.com/index.php?attachment/55666/
Does this help?
Re: counting number of days between anniversary day and payment due date
Quote from Wafoun;679179Display Morehi
i am trying to get the number of days from last time ticket paid till todate, considering the day & month of the hiring date but the year of the last time paid.
say
AAA hired on 15-Nov-2001 receives a ticket every 24 months; received last ticket in Nov 2011.
i want to count
the number of days between 15-Nov 2011 until 31-Jul-2013 (dd & mm are from joining date yyyy from last time paid)
i have a list of 1200 names with different dates of joining and different dates of payments.
thank you
Could you upload your workbook?
Re: Sum values adjacent to random entries of a particular word in a worksheet
You are welcome.
Re: Calculate number of hours worked
Quote from sabal87;679028Display MoreI tried looking at old threads, but I can't seem to find anything that works for my case.
I have a time sheet similar to the one below.
[TABLE="width: 500"]
[tr][td]
day
[/td][td]
time in
[/td][td]
time out
[/td][td]
time in
[/td][td]
time out
[/td][td]
hours worked
[/td][/tr]
[tr]
[td]
Monday
[/td][td]
8:30
[/td][td]
4:30
[/td][td][/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]
Tuesday
[/td][td]
8
[/td][td]
12:30
[/td][td]
1:30
[/td][td]
5
[/td][td][/td]
[/tr]
[/TABLE]
I'm trying to write a code to calculate the hours worked (in both cases 8 for the example above). I've tried different number formats, but I can't find one that works.
Any ideas or comments would be greatly appreciated
Are the only two formats or you can have more?
Is this 8:30 4:30 morning or afternoon?
How do you know this?
Re: Sum values adjacent to random entries of a particular word in a worksheet
=SUM(IF(C4:V24="interest",D4:W24))
Confirm Control+Shift+Enter
or
=SUMPRODUCT(--(C4:V24="interest"),D4:W24)
Re: VLookup/Index to return multiple values
So the Track tab you need all 27786 first, then 28286 ....
This is possible but the user will have to add the numbers.
Is the outocme in Tracj what you expected to return?
Re: Retrieve data in a cell from value in another cell
You are welcome.
Re: Retrieve data in a cell from value in another cell
I have changed the formula.
Spam was there as you had "x" in column Cforum.ozgrid.com/index.php?attachment/55643/
Re: Retrieve data in a cell from value in another cell
Your formula is the same as mine just for Excel 2003 or previous.
IFERROR was introduced in v.07.
Can you post your workbook with te not working solution?
Re: Excel formula for project dates - kind of confused!!
Quote from GreekCPA;678867I think that worked. It looks so simple, but it really threw me for a loop this morning. THANK YOU!!!!
You are welcome
Re: Excel formula for project dates - kind of confused!!
Hello and welcome.
C5
=IF(TODAY()<=A5,0,TODAY()-A5)
D5:
=B5-A5-C5
or
=IF(A5>B5,0,B5-A5-C5)
Re: Array formula looking at a specific value in Column A skip a row and return a val
Could provide an example on how this should look like?
Re: Retrieve data in a cell from value in another cell
Quote from Tikigaq75;678677Display MoreHi,
I have an inventory list in one column and an "x" in the next column if the item needs to be purchased. i'd like to create a shopping list from these 2 columns. What formula do i use to create the list. I'm trying to retrieve the item that has an "x" and would like to create a column of all those that have an "x". I know i can use: =if(isblank(c2),"",c1), however I'll have multiple blank cells that dont contain the "x".forum.ozgrid.com/index.php?attachment/55607/
Thanks!
Re: Calculating overtime in Excel
Could you post your spreadsheet?
Re: Vlookup needs revision
I got problem with download so here is a formula/:
=IF(ISNA(INDEX(Sheet2!$A$2:$AA$46312,MATCH($C6,Sheet2!$F$2:$F$46312,0),MATCH(H$5,Sheet2!$A$1:$AA$1,0))),"",INDEX(Sheet2!$A$2:$AA$46312,MATCH($C6,Sheet2!$F$2:$F$46312,0),MATCH(H$5,Sheet2!$A$1:$AA$1,0)))