Forum Discussion

Jacqueline1615's avatar
Jacqueline1615
Copper Contributor
Aug 21, 2024

Increment Number Based on Passing Specific Date and Time

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.

Resources