| 関数式の作成 |
|
|
|
|
|
| |
日数の計算 |
|
|
|
|
|
| ｾﾙＥ |
ｾﾙＦ |
ｾﾙＧ |
ｾﾙＨ |
|
ｾﾙＪ |
| 4 |
|
|
=F4 |
|
|
|
| 6 |
|
|
|
=C4 |
|
=C12 |
| 8 |
|
|
=F8 |
|
|
|
| 10 |
|
|
|
=C8 |
|
=C12 |
| 12 |
=DATEDIF(L2,$F$12,"y") |
=NOW() |
=F12 |
|
|
|
| 14 |
|
|
|
=C12 |
|
=C16 |
| 16 |
|
|
=F16 |
|
|
|
| 18 |
|
|
|
=C12 |
|
=C20 |
| 20 |
|
|
=F20 |
|
|
|
| ｾﾙＨ |
|
|
|
|
|
| 4 |
=IF(F4<>"",CHOOSE(WEEKDAY(F4),"日","月","火","水","木","金","土")&"曜日","") |
| 8 |
=IF(F8<>"",CHOOSE(WEEKDAY(F8),"日","月","火","水","木","金","土")&"曜日","") |
| 12 |
=IF(F12<>"",CHOOSE(WEEKDAY(F12),"日","月","火","水","木","金","土")&"曜日","") |
| 16 |
=IF(F16<>"",CHOOSE(WEEKDAY(F16),"日","月","火","水","木","金","土")&"曜日","") |
| 20 |
=IF(F20<>"",CHOOSE(WEEKDAY(F20),"日","月","火","水","木","金","土")&"曜日","") |
| ｾﾙＫ |
ｾﾙＬ |
|
|
ｾﾙＭ |
|
| 6 |
=DATEDIF(F4,$F$12,"d") |
=DATEDIF(F4,$F$12,"y") |
|
|
=DATEDIF(F4,$F$12,"ym") |
|
| 10 |
=DATEDIF(F8,$F$12,"d") |
=DATEDIF(F8,$F$12,"y") |
|
|
=DATEDIF(F8,$F$12,"ym") |
|
| 14 |
=DATEDIF($F$12,F16,"d") |
=DATEDIF($F$12,F16,"y") |
|
|
=DATEDIF($F$12,F16,"ym") |
|
| 18 |
=DATEDIF($F$12,F20,"d") |
=DATEDIF($F$12,F20,"y") |
|
|
=DATEDIF($F$12,F20,"ym") |
|
| ｾﾙＮ |
|
|
|
|
|
| 2 |
=IF(L2<>"",CHOOSE(WEEKDAY(L2),"日","月","火","水","木","金","土")&"曜日","") |
| 6 |
=DATEDIF(F4,$F$12,"md") |
|
|
|
|
| 10 |
=DATEDIF(F8,$F$12,"md") |
|
|
|
|
| 14 |
=DATEDIF($F$12,F16,"md") |
|
|
|
|
| 18 |
=DATEDIF($F$12,F20,"md") |
|
|
|
| |
