Problems with dates?

[skint]

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.

 

[Bob Phillips]

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)