Hello, I would like to know how to create a formula that would increment a number based on a certain date and time passing.

For example,

I would like a number to increase by 1 per day after 5pm.

I found how to increment based on a certain date passing:

+(TODAY() – DATE(2024,8,20)

but I would like to add a time.

Also, I am interested in learning how to make a formula where it will only increment if another cell is “N”

I was trying to use an “If” but was having trouble getting it to work.

=IF((B1=”N”,+(TODAY() – DATE(2024,8,20)),0)

does not work but I do not know how to fix it.

If there is anything that needs further explanation or is unclear please let me know.

​Hello, I would like to know how to create a formula that would increment a number based on a certain date and time passing. For example, I would like a number to increase by 1 per day after 5pm. I found how to increment based on a certain date passing: +(TODAY() – DATE(2024,8,20) but I would like to add a time. Also, I am interested in learning how to make a formula where it will only increment if another cell is “N” I was trying to use an “If” but was having trouble getting it to work. =IF((B1=”N”,+(TODAY() – DATE(2024,8,20)),0) does not work but I do not know how to fix it. If there is anything that needs further explanation or is unclear please let me know.  Read More

​