calculate date

[Icechoco]

Qns 1) I have a column eg. Column A. Dates are entered manually into this column. Such as 31.01.06. I would like a pop up message box to indicate that work is overdue after 10 days from this date. How do i do it??

Qns 2) I have a column eg. Column B. Dates are entered manually into this column. Such as 01.02.06. Another date also manually entered into another Column C. How do i calculate the difference in the number of days between Column B & Column C?

[[email protected]]

If you want a pop up box, you need VBA, but if colour coding would do
conditional formatting will do it - however, it won't work if you enter
what you are calling a date as 31.01.06 as this isn't recognised as a
date by Excel - use a / or - instead of the .

answer 2 is =c-b (have the cell formatted as number)

[Arvi Laanemets]

Hi


<[email protected]> wrote in message
news:[email protected]...
> If you want a pop up box, you need VBA, but if colour coding would do
> conditional formatting will do it - however, it won't work if you enter
> what you are calling a date as 31.01.06 as this isn't recognised as a
> date by Excel - use a / or - instead of the .

You are wrong here - it all depends on your regional settings.



--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )

[Arvi Laanemets]

Hi

The difference between dates is calculated as simple substraction
=C1-B1
, and format as number. Or
=DATEDIF(B1,C1,"d")
NB!

To calculate number workdays between 2 dates you can use NETWORKDAYS
function (with Analysis Toolpack installed)

PS. Unlike DATEDIF or date substraction, NETWORKDAYS includes both start and
end days.
=TODAY()-TODAY() returns 0
=DATEDIF(TODAY(),TODAY(),"d") returns 0
=NETWORKDAYS(TODAY(),TODAY()) returns 1 on workday


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


"Icechoco" <[email protected]> wrote in
message news:[email protected]...
>
> Qns 1) I have a column eg. Column A. Dates are entered manually into
> this column. Such as 31.01.06. I would like a pop up message box to
> indicate that work is overdue after 10 days from this date. How do i do
> it??
>
> Qns 2) I have a column eg. Column B. Dates are entered manually into
> this column. Such as 01.02.06. Another date also manually entered into
> another Column C. How do i calculate the difference in the number of
> days between Column B & Column C?
>
>
> --
> Icechoco
> ------------------------------------------------------------------------
> Icechoco's Profile:
> http://www.excelforum.com/member.php...o&userid=34823
> View this thread: http://www.excelforum.com/showthread...hreadid=545769
>