-
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.
prior
-
U
Formula for identifying if date/time is after specific time on the day prior to another date/time
Hi All, I need some help with an IF formula in identifying if DateTime A is after 12:00pm the day prior to DateTime B then 1,0. For example, if DateTime A is 8/17 12:01 and DateTime B is 8/18 23:00, the formula will flag DateTime A as 1 and if not true then 0. My data source is dynamic and is...- ufka1
- Thread
- datetime day formula prior
- Replies: 1
- Forum: Excel Questions
-
A
Obtain prior month via drop down list of months (text value)
I have a drop down list of January thru December as a text value. I'm trying to convert that value to an actual month and calculate the prior month so I can ultimately use that in a vlookup. I've tried a number of manipulations but nothing works.... I have too much work done to change the...- anderma8
- Thread
- drop list month prior text
- Replies: 3
- Forum: Excel Questions
-
J
Calculated field that references a cell in that row, and the entire field
Is it possible to reference a *cell* in a calculated field of access? I want to add a column that takes the average of the "price" column, if the "product ID" column matches the "product ID" of that row, and the "date" column is less than the date in that row. <tbody> No. Product ID Date...- jwb1012
- Thread
- average if calculated column multiple criteria prior
- Replies: 7
- Forum: Microsoft Access
