Question about time...

Hi,

I have tried and tried so many times but I just can't figure it out. I wanted to know how to trigger a response when a set time has finished. It's like a deadline indicator. When NOW() time is later than a stated time by 30 days, I want something to happen. Is it possible to integrate IF() with this?

Thanks.

Hi,

You could try this

=IF(A1-TODAY()+1>30,"Your Formula","")

Change "Your Formula" to what you need to happen

VBA Noob

And what's A1?

I assumed it was the reference date I was talking about. Apparently it doesn't work. Typing it out gives a value of zero when the reference date was in february. When I use the guided approach, it says that the logical statement is "volatile". The reference that I was talking about is only formed of dates and no time, like 1/2/2006.

Thanks for the reply.

Can you post an exaple of data and expected result

VBA Noob

Look at the picture. What I expect it to do is calculate the number of days between today's date and that date on A1, and output the number. But instead of making it output the number, insert it into a logical statement so that something would appear in A2 if it is more than 30 days, and nothing would appear if it is less than 30 days.

Hi,

It's a negative date. You must enter the formula as

=TODAY()-A1+1

VBA Noob

Ok, I have reversed the TODAY() and A1 positions. Without the +1 behind, it would display a date. However, excel is assuming (mind me for I use dd/mm/yyyy format) 17/9/2006 minus 1/2/2006 to give me something funny like 15/7/1900. Perhaps I have to convert the dates to days on a year first before arithmetically deducting them?

How format the cell as General

VBA Noob

Oh so it was just a matter of cell formatting...

Ok, now I got it. Thanks a ton!