All Questions
52
questions
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 ...
- 672
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. ...
- 66
1
vote
1
answer
349
views
Update cell value based on dates in other columns
I would like to:
Update a cell (A2) with a status. That could be a standardised list, for example: "Sent to Customer", "Customer Replied", "Task Closed".
There are three ...
- 5,126
0
votes
1
answer
79
views
get a cell in the closest row of the previous year end
I have a row in mid year which I want to get the tax value of the previous year-end row.
Sometimes it will be year-12-31 and sometime there will not be that date, but a few days before it.
So in B17 ...
- 127
2
votes
1
answer
916
views
Using a date in an Excel function does not work when the date comes from another cell
I have the following problem: using a date as a condition in an MS Excel function works fine, as long as I write the date in the function code, such as ">1.1.2022".
But when I write the ...
- 276
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 ...
- 24
0
votes
3
answers
20k
views
Don't show 1900 on blank date
I have a spreadsheet that converts the date in one cell to a year in another. I want to pull the formula down so that it automatically shows the date in columns A and B if there is a date in column C; ...
- 1
1
vote
2
answers
324
views
I Need To Compare 4 Dates Against Today's Date To Get A Yes Or No Result
I have 4 cells on the same row that are either blank or contain a date (YYYY-MM-DD), which I need to compare to today's date. If any one cell is blank or occurs in the past, I want the result to ...
- 11
2
votes
1
answer
22k
views
Inserting Today's Date In A Cell If Other Cell Values Are Changed or Added [duplicate]
I have a spreadsheet with a column labeled, "Status Date," in a row with several other cells, some with other dates, some with just text, and others which evaluate whether a set of ...
- 3,134
0
votes
3
answers
5k
views
IExcel not comparing dates properly
I have a table with two dates in the following format:
C1 Sep 21, 2017 10:22 AM
C2 Sep 28, 2017 10:09 AM
If I run the following if statement against them...
=IF(M4<L4, "Fail", "Pass")
......
- 21
1
vote
2
answers
2k
views
Finding the MAX value over a range but if one row is blank, the value for MAX must be blank
I want to do a MAX value for the latest date in my data for the "Actual" column, but, say that one cell has no date, I want the MAX (in yellow) to be blank too. Any help would be appreciated!...
- 9,274
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
- 8,931
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
64
views
Excel data query
I'm trying to build out a budget monitoring spreadsheet. I want to pull sum of entries by category and based on the month. The data is in rows as follows and will grow each month as I download our ...
- 2,983
1
vote
2
answers
1k
views
Excel won't recognize timestamp in format of "m/d/yyyy h:mm:ss AM/PM"
I have a column of timestamps (strings) formatted like so:
This can be deduced to the following format: m/d/yyyy h:mm:ss AM/PM
I'm trying to get them to be formatted into dates but Excel refuses for ...
- 23.4k