calculate date and number field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Is the 13 the number of weekdays or the number of days?
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Changing Sum Range Based on Date Chosen from Drop Down List 1
Excel How to calculate in excel number of open actions that expired (older then today) 0
Calculate within a time range with only start date and end date 2
Networkdays two years 4
Excel Formula - Count Dates from another Sheet 8
No of Days between two dates and offset formula 4
Excel PRICE function: How does it compute Issue Date of the Security 5

Back
Top