-
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.
check date
-
H
How to adjust staking plan to check date
Hi I have a sheet which handles some calculations for staking, profit & loss and bank size, but I'd like it to be able to do a couple of additional things. Here is the code I currently have =IF(E2="","",IF(E2<3.5,K1*0.01,IF(E2<7.45,K1*0.006,IF(E2<11.1,K1*0.004,"0")))) What is does is to look...- honkin
- Thread
- check date
- Replies: 0
- Forum: Excel Questions
-
M
Check Redo Based on Date difference
Hi, I am looking for a solution to check redo based on multiple criteria. There are basically 2 values in column P and Q it should check both in another sheet named "Previous" if value of P Q matches values in "Previous" and is with 1 month (matching value "Visit") or 3 months (Matching value...- mohdamir1989
- Thread
- check date lookup 3 rows / col lookup between sheets redo visit
- Replies: 14
- Forum: Excel Questions
-
P
VBA check if date in cell is between 1st and 15th of current month
I'm banging my head against my monitor here. Dealing with dates and VBA feels like ironing my tongue. What am i doing wrong in this code? I just want to do 2 things. If the cell in column 68 is blank, do nothing. If its not blank, check the date to see if its between the 1st and 15th of...- powercell99
- Thread
- check date
- Replies: 3
- Forum: Excel Questions
