calculate date and number field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

boo - 21 Feb 2007 03:32 GMT

I need to know if certin forms are out of date. This is a piece of the table
below.

Start Date    Duration Expired Yes/No
1-Jan-07    13
1-Jan-07    13    Yes
1-Jan-07    13    Yes

Need a macro or funtion to be set up so excel can calculate the date it
expired (do not count Saturday and Sunday) and how many days it has been
expired.

Thank you

Reply to this Message

john - 21 Feb 2007 10:32 GMT

Is the 13 the number of weekdays or the number of days?

Signature

John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

> I need to know if certin forms are out of date. This is a piece of the table
> below.
[quoted text clipped - 9 lines]
>
> Thank you

Reply to this Message