Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with dates?
Hi all
How can I set up a spreadsheet where I can enter one date and see in another cell a date say 156 days from that first date? Also how could I show say a date being the first day of sickness the next box showing the last date of sickness and the final box showing how many days are inbetween these two dates based on a 6 day week of Monday to Saturday and also a 5 day week based on Monday to Friday. Many thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with dates?
"skint" wrote in message oups.com... Hi all How can I set up a spreadsheet where I can enter one date and see in another cell a date say 156 days from that first date? =A1+156 and format as date Also how could I show say a date being the first day of sickness the next box showing the last date of sickness and the final box showing how many days are inbetween these two dates based on a 6 day week of Monday to Saturday and also a 5 day week based on Monday to Friday. Mon to Fri =NETWORKDAYS(first_date,end_date) Mon to Sat =SUMPRODUCT(INT((MAX(end_date,start_date)-WEEKDAY(MAX(end_date,start_date)+1 -{2;3;4;5;6;7})-MIN(end_date,start_date)+8) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pre-1900 dates | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Automatic shading of cells based on dates??? | Excel Worksheet Functions | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Problems copying street addresses and dates | Excel Discussion (Misc queries) |