Calculate only if NOW is between 2 dates...

[Excelic]

Hello!

I'm stuck on a date calculation, it should be fairly simple but not for me...

Basically, I need a calculation to take place only if NOW is between 2 specific dates, otherwise I need it to be zeroed out.

This is the picture:

http://img159.imageshack.us/img159/6...ulationdj0.jpg

Thx in advance.

[NBVC]

Try:

Please Login or Register  to view this content.

edit:

Probably better to use Today() if the actual time is not relevant....because if both dates and times are the same, you may not get the desired results

so...

Please Login or Register  to view this content.

[Excelic]

Thanks, it worked!