Date question

  • Thread starter Thread starter GR
  • Start date Start date
G

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
 
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
 
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?
 
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
 
And thank you for posting back with thanks!... I added one
more entry under GB's entry regarding the printing issue...

Cheers
Juan
 
Back
Top