Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate date and number field
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate date and number field
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) "boo" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can anyone calculate age next birthday from date field? | Excel Worksheet Functions | |||
How to convert date field to number value | New Users to Excel | |||
How do I calculate the number of quarters between two date | Excel Discussion (Misc queries) | |||
How can I calculate the week number from a date, eg 21/06/05 = 26 | Excel Worksheet Functions | |||
calculate the number of days from date received | Excel Worksheet Functions |