-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
dates in excel
-
A
Making the dates uniform in excel
Dear All, I have a large data set with 16,000 values. I need to extract the start date from the column. However, the dates are in different forms. Some have a single date wherein some contains ranges like 06-06-2019 - 08-06-2019. Is there a way wherein I can convert these into a single date...- ak241987
- Thread
- date dates dates in excel flash fill single
- Replies: 1
- Forum: Excel Questions
-
M
i need formula for dates
Experts, I am attempting to make a payroll calendar and paycheck distribution date. I have the start date in A1 and to make my bi-monthly dates, A2 has the formula =IF(DAY(A1)<15,DATE(YEAR(A1),MONTH(A1),15),DATE(YEAR(A1),MONTH(A1)+1,0)) I am trying to place a formula in A3 that would calculate...- MAP
- Thread
- date dates in excel formula make weekday formula
- Replies: 4
- Forum: Excel Questions
-
C
Help with Dates in Formula
Help please. I need a formula that will add 15% to a date. If the resulting date is a Saturday, the date needs to be moved back to Friday. If the resulting date is a Sunday, the date needs to move up to Monday. Here's what I'm using now: - B5 is a start date - B6 is an end date - B7 calculates...- cr2289
- Thread
- b10 date dates in excel formula formulas with dates
- Replies: 1
- Forum: Excel Questions
