All Questions
52
questions
0
votes
1
answer
269
views
Excel: conditional formatting with with complex function AND
I have a sheet that looks like this:
So I have a list of documents to create, and I mark "1" on the column with the month in which I have created them.
Now I've been asked to put "1" also as a ...
0
votes
1
answer
20k
views
Excel Pivot Table - How can I return a date in the row value?
I have raw data that includes hundreds of employees who have completed many different training courses and I am needing to insert a pivot table that shows the course name as the column labels, the ...
0
votes
1
answer
121
views
Grab cell data and use in "IF" statement
Is it possible to grab a cell containing a date and paste that date in an "IF" statement containing text, similar to the below:
=IF(OR(I1=TRUE,J1=TRUE),"Date:___________________",IF(AND(I1=FALSE,J1=...
1
vote
1
answer
665
views
How to count months in intersection of two date ranges [closed]
I need to calculate the number of months in the intersection of two date ranges.
For instance, in Column A I have start dates of employment
12/1/1998, 1/1/2003, 2/1/1995
and in column B I have ...
0
votes
1
answer
251
views
Looking for a formula(s) that will return the next date (higher than the starting date) from a row of dates, then the next date from that one
Worksheet 1 lists all of the "legs" flown by our aircraft. The leg or legs for each day would then go to Worksheet 2 for Day 1, Worksheet 3 for Day 2, and so on. Legs are listed in columns starting ...
5
votes
2
answers
116
views
Formatting Dates
I have the following formula:
=D56&" "&"("&D57&" Days"&")"
D56 has a date within the cell. I want to format the date like 5/5/2011 but I'm not sure how to do it.
1
vote
3
answers
329
views
check of date with functions lookup
i have input date in sheet1 say in A! 15/07/2010 and in another sheet range of dates with interval of six months in a1 01/01/2010 and in b1 30/06/2010 and c1 15 likewise data is there
i want to ...