Hi everyone
Happy new year before all!!!! I have got a problem with a date, in fact I would like to change a value of a cell if the date of the system is > 31/02/2007 (very basic) but it can compare dates only if they are in the same month: for example, today we are the 10th so it can compare the today's date only with all the days of january, once it becomes 01/02/2007 it doesn't work.
my macro is If Date$ is >#31/02/2007# then Activecell.Value = #nothing done#.
Do you know how I can solve this ??
Thanks
Bookmarks