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.

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)