All Questions
8
questions with no upvoted or accepted answers
3
votes
0
answers
178
views
Excel formula to work out time elapsed between dates based on very specific criteria
I have a dataset with approx. 29,000 entries related to approx. 3000 unique individuals’ admission and departure dates to and from a service over a period of time.
I’m trying to collapse each ...
- 41
0
votes
1
answer
66
views
EXCEL FORMULA - Conditional format Date
I am trying to work out a formula for the below specific Critia.
If cell is blank, colour in yellow if date is 2 days away, colour in red if date has 1 day over.
I am trying to build a traffic light ...
0
votes
1
answer
157
views
I am trying to get excel to automatically insert date when another cell is changed
I have tried the following:
=IF(A1<>"",IF(B1<>"",B1,NOW()),"").
and enabled iterative calculation.
It still updates to the time when I open the spreadsheet. ...
- 1
0
votes
1
answer
166
views
How to Calculate the Average after a certain date
Im trying to get the average of days taken to send to college but i only want it to take in to consideration dates received after 17/05/2021.
can anyone help
0
votes
0
answers
942
views
Infinite date column in Excel
I saw an Excel spreadsheet once that had a date column that would span a couple of month down and that would be the end of the spreadsheet, but every day you open and use it, that date at the bottom ...
0
votes
3
answers
593
views
How to find which column contains the first occurance of a number in a single row? (Excel)
I have an Excel sheet with over 100 dates as column names and hundreds of locations as row names.
There are numbers (could be any number) somewhere in each row that indicate that an event will occur ...
0
votes
2
answers
138
views
Excel switching year and month for some cells but not others
I have been given a spreadsheet with dates that are being inconsistently formatted by Excel. Since dates were entered into the spreadsheet as mm/dd/yy (i.e. no four-digit years), Excel has assumed the ...
- 1
0
votes
1
answer
330
views
Sophisticated dates sorting in MS Excel?
There is an Excel 2016 file with data about some events, the main sheet contains an ID and a date for each event, like this:
ID Date
1 2017-10-02
2 2017
3 2017-09
4 2017-09-25
… etc.
Most ...
user628454