All Questions
52
questions
0
votes
1
answer
42
views
Excel Weekday Generation
I have a list of dates in a row. I just want the row above them to tell me which day of the week the corresponding date (below) fell. For example, today (30 Jan. 2018) would output "Tuesday", because ...
1
vote
1
answer
83
views
excel and birthday format
I am new to this. I do not have a screen shot for this one.
In the region I am located the birthdays are listed as: yy-mm-dd
I have: 720415 and want to convert it to: 72-04-15.
Will following work:
=...
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 ...
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
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 ...
0
votes
3
answers
716
views
calculate datedif and stop once column filled in
I want to calculate days on wait list (0 if the assessment date column is not filled in), calculate date from today minus the referral received date, and then stop the calculation when the date of ...
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, ...
1
vote
1
answer
64
views
How do I extract dates from a weekly tracker?
Let's say in each hour of the day in a week I record for example the food I eat or the physical activity I do.
At the end of the week, I have a table where the rows are hours (12am-12:59am to 11pm-...
0
votes
1
answer
2k
views
Add a calculated HH:MM:SS to the Current time in excel?
I've made a spreadsheet to quickly calculate how long a 3D render will take based on number of frames & minutes per frame.
However I'm also wanting to add a calculation that shows the time and ...
0
votes
2
answers
103
views
Difference in dates
There are two dates : 01-11-2008 and 28-02-2017 (in dd/mm/yy format). I want excel to calculate the difference between these two dates and give the output in whole years.
If the difference between ...
0
votes
1
answer
107
views
Excel formula for auto fill a date
I would like to have cells F4-F23 auto fill today's date whenever data is entered into cells E4-E23. I then need to have cells I4-I23 auto fill with today's date whenever data is entered in cells H4-...
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 ...
0
votes
1
answer
156
views
Date formula in excel regarding calendar
I need to fill in a Day and Date column in an Excel table to create a one month calendar:
Select a year: 2016
Select a month: September
-------------------------
| Day | Date |
|---------...
0
votes
1
answer
99
views
date calcutation in excel based on other dates
=TODAY
date A date B date C
I need formula which will calculate me date B.
I.e. If between date A and =TODAY has passed more then a year and if date C is empty then date B will be same as =...
0
votes
1
answer
272
views
Excel - Multiplying daily values for each week
What I have: over 200 rows, each with three values, each for a unique day. Only values for workdays are listed, so sometimes there may be days or even whole weeks missing from the list because of ...