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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

infojacques@gmail.com - 12 Jul 2007 20:57 GMT

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

Reply to this Message

Pete_UK - 12 Jul 2007 21:25 GMT

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

On Jul 12, 8:57 pm, infojacq...@gmail.com wrote:

> Hello,
>
[quoted text clipped - 8 lines]
>
> Jacques

Reply to this Message

infojacques@gmail.com - 13 Jul 2007 08:57 GMT

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

Reply to this Message

Pete_UK - 13 Jul 2007 10:08 GMT

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

Pete

On Jul 13, 8:57 am, infojacq...@gmail.com wrote:

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

Reply to this Message