All Questions
52
questions
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 ...
0
votes
1
answer
1k
views
Excel formula to calculate date based on 2 cells and how to copy to other cells?
Novice excel user here. Here is a simplified version of my spreadsheet:
start date end date eday duration
-21 4
12 0
begindate = "03/...
0
votes
2
answers
2k
views
Formula for Index/Match with multiple criteria WITH date range EXCEL
I am attempting to write a formula that will help pull data from column D into column H (currently populated but would be blank).
Logic is as follows: If any of the IDs in column A are in the range ...
0
votes
1
answer
692
views
Auto fill blank cells in Excel
I have downloaded sales data from webstore and the rows are itemised, but they only provide the date in one cell for the order.
I am trying to work out how I can auto fill the blank cells with the ...
0
votes
2
answers
3k
views
How to keep cell blank until date entered [duplicate]
So basically, "INVOICE DUE DATE" is the SUM of D11+7 ("Date invoice sent out" + 7 days as this is when the invoice is due). However, when there is no date inputted in "DATE INVOICE SENT OUT" the "...
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 ...
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 ...
0
votes
1
answer
111
views
Excel - Find the document of a given type, with the closest due date
I am operating on 2 Tables.
"Table 1" is a list of current documents that I import and want to keep unchanged. The file is unformatted in any way.
Table 2 is a list of customers that I operate upon ...
0
votes
2
answers
78
views
change 2017/2/3 to 2017/02/03
I have a column in Excel which shows date but not in date format, it is in text format and the values for those dates that have one character for the month or day don't contain a zero before them.
E....
1
vote
1
answer
364
views
How do you round a time and date back to a previous day with a formula in excel?
I am trying to sum up hours for an employee worked in one shift. The employees I'm having a problem with are on night shift. The employees entries in excel are shown as individual tickets for work ...
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")
......
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-...
1
vote
1
answer
860
views
Writing a formula to count how many times each date appears in a set of date ranges
Given an Excel spreadsheet with two columns:
Creation Date, Closure Date
For each date covered by all date ranges over all columns, I want to know how many records cover each day.
For example:
...
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 ...
0
votes
1
answer
46
views
Excel: Use date-format only on date strings that match a pattern
I'm using Excel from Office 365
I have a date column that has three types of date strings:
string # 1: 12/9/2016 0:00 # this string has month, day, year, hours, minutes
string # 2: 201605 # this ...