Login Page - Create Account

Support Board


Date/Time: Wed, 02 Jul 2025 06:12:25 +0000



Post From: Spreadsheet question

[2020-04-13 03:19:17]
Sawtooth - Posts: 4231
P1 is a time value, like this: 14:15:00

If P1 is a DateTime value, use this formula:
=IF(AND($P$1>=A3,$P$1<A2),B3,P4)
but this will only return one value because P1 is only one day, and only if that day is within the range of the spreadsheet sheet.

The formula uses A3 and A2 so that the returned value is in the correct row.