All Questions
108
questions
0
votes
0
answers
27
views
Conditional Format Date From Date In Another Cell
I have three date columns, Manufacture Date (B2), Inspection Date (C2), Future Inspection Date (D2), the Future Inspection Date column looks at columns B2 & C2 to determine the latest date from ...
1
vote
1
answer
202
views
Lookup and get date of lower range for in between date in Excel Formula
Dataset 1:
ID
Date
Item
1
5/10/2022
Apple
1
1/10/2022
Orange
1
10/10/2022
Strawberry
2
1/10/2022
Kiwi
Dataset 2:
ID
Date Modified
Item
1
30/9/2022
1
4/10/2022
1
9/10/2022
1
11/10/2022
2
9/...
0
votes
1
answer
594
views
Weighted average using dates
I have data which shows the number of apartments under construction, and their estimated completion date.
Is there a way to calculate the weighted average completion date; e.g. If I have 10 apartments ...
0
votes
2
answers
178
views
Excel formula required on start and finish date
I am looking to find a formula to show a "Start date" based on the first date entry and also "Finish date" if the there is no date against a person's name since last two months. I....
0
votes
1
answer
26
views
Excel specific formula required based on date
I am looking to find a formula to show a value or text for those who have "left" if the current month is no longer listed against their name, as well as if the current month is listed they ...
0
votes
0
answers
364
views
Excel Formula that identify whether a date is in the list of dates
I have a list of dates in Excel :
22/07/2022, 23/08/2022, 24/09/2022
I want to identify whether a specific date (current date) is in the list of dates. (E.g. 24/09/2022)
What formula shall I use ?
I ...
0
votes
0
answers
77
views
Max (date) # - Min(Date) # to get the weight difference - Excel Formula
I have different entries for the weight over different periods of time and wanted to see the weight difference from the max point in time to the min point in time based on a specific ID.
ID Date ...
1
vote
2
answers
202
views
How to compare two dates in a text string in excel?
I have a set of data with this format:
Each cell has one or some names, each of them are followed by a date. I want to compare the dates which are presented in each cell and check whether they are the ...
1
vote
2
answers
2k
views
Excel - RIGHT formula not working as expected
I am trying to get the last 4 characters (the year in this case) from one column to be displayed in a new column. As far as I am aware, the formula I am doing is correct but the column isn't ...
0
votes
2
answers
658
views
Returning Previous Quarter and Year Google Sheets
I am having trouble writing a formula in Google sheets that will return the previous quarter based on today's date.
For example, if I have cell A1 as =today() which is 1/26/22, I would like cell B1 to ...
0
votes
1
answer
1k
views
Excel Formula calculating the starting date of a given calendar week
Given a table with the following entries:
A B C D
1
2
3 Calendar Week Year Start Date End Date
4 5 2022 31/01/2022 06/02/200
...
0
votes
0
answers
94
views
Search excel range for a specific column matching todays date
My Excel formula searches for a range of cells and cell that matches the date is outputted in a separate cell. That cell contains the function below. What I would like to do is instead of displaying ...
0
votes
1
answer
627
views
Formula to select a date 3 business days later than the cell on its left
In my Excel workbook, I have "November 10th". I want every cell in the column to the right to display a date 3 days later, but it has to be a weekday Monday - Friday, it can't fall on a ...
0
votes
2
answers
2k
views
Excel Date Formula + 3 Months
I am looking to have a formula that takes the date that is manually input in a cell (E2) and automatically populates a date in the column next to it (F2) that is + 3 months from the date manually ...
-1
votes
1
answer
33
views
setting the same values as for another tab
In excel tab called "A" in column A1 I would like to assign date the same as in tab "B" column A1 However when column with dates from "B" is empty it should be empty for ...