All Questions
52
questions
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.
3
votes
3
answers
4k
views
Formula to set date to nearest previous (most recent) 25th of the month
I need a couple things here, but I think they may be similar formulas:
I have a list of dates in an Excel file (Column A). I'd like to create a 2nd list (Column B) that will have a formula that will ...
3
votes
1
answer
193
views
Excel: Keep cell containing date the same after being set, without macros
I have a table that looks like this:
What I want to achieve is that when you fill in a row (other than the 'Time' section), the 'Time' column automatically fills itself in. Then, it stays the same ...
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 ...
2
votes
2
answers
647
views
Excel: find the nearest (to a reference one) date for each row
I'm not an Excel expert (not by far) and I've been having a hard time finding a solution for the following problem. I have a table that represents the scheduled day of shift (A) for each employee (B) ...
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 ...
2
votes
2
answers
8k
views
Multiple date formats in single column in excel
I have a csv file with a date column with dates in various forms as follows:
dd-mm-yyyy
yyyy-mm-dd
yyyy-mm
yyyy
This irregular data is in a single columns.
How do I convert all of them to the dd-...
2
votes
1
answer
203
views
Excel: flaw in date calculation - hashed when formula is examined (corrected by backfill)?
NOTE: I have corrected this fault... but an answer ideally requires an explanation (if anybody can explain it great).
A formula determining the end or beginning of a quarter works perfectly.
However, ...
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 ...
2
votes
1
answer
2k
views
Calculate Gregorian Julian Date from Regular Date in Excel
I am trying to get a Julian Date from a regular date (mm/dd/yyyy) in Excel. There seems to be two kinds of Julian date calculation.
One is described Here..
The other is somehow related to Gregorian ...
1
vote
2
answers
8k
views
Concatenated cells return random number instead of date
I have a question about an excel formula.
I have a some fields I want to concatenate together. One of those is a date made with the formula TODAY.
When I concatenate all together it will give me a ...
1
vote
1
answer
673
views
How do I add 1 month to a specific date once that date has passed?
I have an excel sheet that lists our current due date. The due dates are the same day of each month (9/2, 10/2, etc) and I want the due date to update once the old date passes so I don't have to do ...
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 ...
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 ...
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!...