Date question

[GR]

I need to tie the date with an event. ie. if the date is
between the 1st and 15 an amount will be entered if the
date is between the 16th and the end of the month no
amount will be entered. I would like to tie it in the
=date() formula.
Thanks

 

[Eric]

Assuming you have used the =DATE() command to generate
the date, you should be able to use something like this:

=IF(DAY(A1)<=15,1000,"")

Any reason that won't work?

Eric

 

[Juan Sanchez]

GR

try this:

=IF(DAY(DATE(Y,M,D))<=15,{AMMOUNT HERE},"")

Cheers
Juan

 

[GB]

Thanks very much for your quick response, it works
fine, except I need a message to print when the date
exceeds the 15th. any ideas?

 

[Guest]

Thanks for your quick response, this works o.k.

-----Original Message-----

GR

try this:

=IF(DAY(DATE(Y,M,D))<=15,{AMMOUNT HERE},"")

Cheers
Juan


.

 

[Juan Sanchez]

Eric...

Do you actually need the messge to print out thru a
printer if the day exceeds the 15th or do you want a
message to appear in the cell, or do you want a pop-up
message to pop-up on the screen.

For a message to appear on the cell:

=IF(DAY(DATE(Y,M,D)<=15,1000,"YOUR TO LATE")

For the other two you need code, please post back if you
want code...

cheers
Juan

 

[Juan Sanchez]

And thank you for posting back with thanks!... I added one
more entry under GB's entry regarding the printing issue...

Cheers
Juan

 

[Guest]

The message works fine, how do you know all this
stuff?
Thanks again

 

[Juan Sanchez]

Snooping arround the community news groups...

Cheers
Juan