::: Date Comparison Problem or Date Formula or Date Macro :::

[infojacques]

Hello,

Could anyone help me with a date comparison problem.

It can be solve with a format (I hope), or a formula (maybe), or a
macro (help)?

I explain it all into this Excel file: http://cjoint.com/?hmv2gAKKDz

Many thanks in advance for your support and help.

Jacques

 

[Pete_UK]

Question 2: If you enter a date as 12/7 or 12 July, Excel will assume
you are trying to enter a date and will default the year to 2007 (this
is in the UK - if you are in another country it will depend on your
default date format for days, months and year: you might have to enter
7/12). You should format the cell (as you have done) using a custom
format of dd mmmm to display it as 12 July. If you want the date to
refer to another year, you will need to enter 12/7/08 (or possibly
7/12/08), but it will still display as 12 July.

Question 3: Enter this formula in C19:

=IF(AND(DAY($B19)=DAY(C$15),MONTH($B19)=MONTH(C$15)),"Action
Required","Keep going")

and then copy it across and down as required.

Hope this helps.

Pete

 

[infojacques]

Thank you for your answer.
It is working perfectly!
Enjoy your we!
Jacques

 

[Pete_UK]

Thanks for the feedback, Jacques - glad to be of help.

Pete