{"id":155,"date":"2011-01-26T13:56:35","date_gmt":"2011-01-26T04:56:35","guid":{"rendered":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/?p=155"},"modified":"2026-04-02T09:09:55","modified_gmt":"2026-04-02T00:09:55","slug":"post-93","status":"publish","type":"post","link":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/2011\/01\/post-93.html","title":{"rendered":"\uff08\uff18\uff18\uff09Excel\u3067\u4eca\u65e5\u306e\u65e5\u4ed8\uff08\u884c\uff09\u306b\u8272\u3092\u4ed8\u3051\u308b\u65b9\u6cd5\u266aTODAY\u95a2\u6570\u266a"},"content":{"rendered":"<div>\u4eca\u65e5\u306f\u4f1a\u793e\u3067\u30bb\u30df\u30ca\u30fc\u3092\u958b\u50ac\u3057\u3066\u3044\u307e\u3059\u3002<\/div>\n<p><span class=\"mt-enclosure mt-enclosure-image\" style=\"display: inline;\"><a href=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/images\/riv0025-026.JPG\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"mt-image-right\" style=\"float: right; margin: 0 0 20px 20px;\" src=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/assets_c\/2011\/01\/riv0025-026-thumb-200x123-2178.jpg\" alt=\"riv0025-026.JPG\" width=\"200\" height=\"123\" \/><\/a><\/span><\/p>\n<div>\u30e2\u30ab\u306f\u4eca\u65e5\u306f\u53d7\u4ed8\u3092\u62c5\u5f53\u3055\u305b\u3066\u3044\u305f\u3060\u3044\u3066\u304a\u308a\u307e\u3059\uff3e\uff3e<\/div>\n<div><\/div>\n<div>\u305f\u304f\u3055\u3093\u306e\u65b9\u304c\u4eca\u65e5\u306e\u30bb\u30df\u30ca\u30fc\u306b\u5fdc\u52df\u3057\u3066\u304f\u3060\u3055\u308a\u3001<\/div>\n<div>\u5b9a\u54e1\u3044\u3063\u3071\u3044\u306b\u306a\u308a\u307e\u3057\u305f\uff01<\/div>\n<div><\/div>\n<div>\u524d\u65e5\u3001\u30c6\u30fc\u30d6\u30eb\u3092\u62ed\u3044\u305f\u308a\u3001\u914d\u7f6e\u3092\u6574\u3048\u305f\u308a\u3001<\/div>\n<div>\u6c17\u6301\u3061\u3088\u304f\u30bb\u30df\u30ca\u30fc\u3092\u53d7\u3051\u3066\u3044\u305f\u3060\u3051\u308b\u3088\u3046\u306b\u3001\u5fc3\u3092\u3053\u3081\u3066\u6e96\u5099\u3055\u305b\u3066\u3044\u305f\u3060\u304d\u307e\u3057\u305f\u3002<\/div>\n<div><\/div>\n<div><b><span class=\"Apple-style-span\" style=\"font-size: 1.25em;\">\u4e00\u671f\u4e00\u4f1a<\/span><\/b>\u3000\u3068\u3044\u3046\u8a00\u8449\u304c\u3042\u308a\u307e\u3059\u3088\u306d\u3002<\/div>\n<div><\/div>\n<div>\u4e00\u77ac\u4e00\u77ac\u306e\u51fa\u4f1a\u3044\u3092\u5927\u5207\u306b\u3057\u305f\u3044\u3001\u3068\u304a\u5ba2\u69d8\u3092\u304a\u8fce\u3048\u3059\u308b\u305f\u3073\u306b\u3044\u3064\u3082\u601d\u3044\u307e\u3059\u3002<\/div>\n<div><\/div>\n<div>\u3053\u308c\u304b\u3089\u3082\u672b\u6c38\u304f\u826f\u3044\u304a\u4ed8\u304d\u5408\u3044\u3092\u3001\u305d\u3057\u3066<\/div>\n<div>\u305d\u308c\u305e\u308c\u306e\u4f01\u696d\u69d8\u306b\u304a\u5f79\u306b\u7acb\u3066\u305f\u3089\u3001\u3068\u601d\u3044\u306a\u304c\u3089\u304a\u5ba2\u69d8\u3092\u304a\u8fce\u3048\u3057\u307e\u3057\u305f\u3002<\/div>\n<div><\/div>\n<div>\u3053\u306e\u5f8c\u3082\u3001\u307e\u3054\u3053\u308d\u3092\u3053\u3081\u3066\u3001\u5145\u5b9f\u3057\u305f\u30bb\u30df\u30ca\u30fc\u306e\u6642\u9593\u3092\u904e\u3054\u3057\u3066\u3044\u305f\u3060\u3051\u308b\u3088\u3046\u306b\u3001<\/div>\n<div>\u304c\u3093\u3070\u308d\u3046\u3001\u3068\u601d\u3044\u307e\uff5e\u3059\u266a<\/div>\n<div><\/div>\n<div>\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6<\/div>\n<h2>Excel\u3067\u4eca\u65e5\u306e\u65e5\u4ed8\uff08\u884c\uff09\u306b\u8272\u3092\u4ed8\u3051\u308b\u65b9\u6cd5\u266aTODAY\u95a2\u6570\u266a<\/h2>\n<div><\/div>\n<div>\u30b9\u30b1\u30b8\u30e5\u30fc\u30eb\u8868\u306a\u3069\u3067\u3001<\/div>\n<div>\u4eca\u65e5\u306e\u65e5\u4ed8\u306e\u6b04\uff08\u884c\uff09\u306b\u8272\u304c\u4ed8\u304f\u3068\u3001<\/div>\n<div>\u4ed6\u306e\u65e5\u4ed8\u3068\u9593\u9055\u308f\u305a\u3001\u30b9\u30e0\u30fc\u30ba\u306b\u5165\u529b\u3067\u304d\u3066\u4fbf\u5229\u3067\u3059\u3088\u306d\u266a<\/div>\n<div><\/div>\n<div><a href=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/2011\/01\/post-91.html\" target=\"_blank\" rel=\"noopener\">\u524d\u56de<\/a>\u306b\u3064\u3065\u3044\u3066\u3001\u6307\u5b9a\u3059\u308b\u884c\u306b\u81ea\u52d5\u7684\u306b\u8272\u3092\u3064\u3051\u308b\u65b9\u6cd5\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/div>\n<div>\u4eca\u56de\u306f\u3001TODAY\u95a2\u6570\u3092\u4f7f\u3046\u65b9\u6cd5\u3067\u3059\u3002<\/div>\n<div><\/div>\n<div><\/div>\n<div>\u8272\u3092\u4ed8\u3051\u308b<b>\u7bc4\u56f2\u3092\u9078\u629e<\/b>\u3057\u3066\u3001<b>\u300c\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u300d<\/b>\u3092\u62bc\u3057\u307e\u3059\u3002<\/div>\n<div><span class=\"mt-enclosure mt-enclosure-image\" style=\"display: inline;\"><a href=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/images\/today2.jpg\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"mt-image-none\" src=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/assets_c\/2011\/01\/today2-thumb-350x231-2165.jpg\" alt=\"today2.jpg\" width=\"350\" height=\"231\" \/><\/a><\/span><\/div>\n<div><\/div>\n<div><b>\u300c\u6570\u5f0f\u304c\u300d\u300c<span class=\"Apple-style-span\" style=\"font-size: 1.25em;\">=$A3=TODAY( )<\/span>\u300d\u3000<\/b>\u3068\u5165\u529b\u3057\u307e\u3059\u3002<\/div>\n<div>\u203bA3\u306f\u65e5\u4ed8\u306e\u30bb\u30eb\uff08A\u5217\u3060\u3051\u7d76\u5bfe\u53c2\u7167\u306b\u3057\u307e\u3059\u3002\u6570\u5f0f\u306e\u5165\u529b\u4e2d\u306bA3\u30bb\u30eb\u3092\u30af\u30ea\u30c3\u30af\u3057\u307e\u3059\uff09<\/div>\n<div><span class=\"mt-enclosure mt-enclosure-image\" style=\"display: inline;\"><a href=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/images\/today5.jpg\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"mt-image-none\" src=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/assets_c\/2011\/01\/today5-thumb-350x99-2171.jpg\" alt=\"today5.jpg\" width=\"350\" height=\"99\" \/><\/a><\/span><\/div>\n<div><\/div>\n<div><b>\u300c\u66f8\u5f0f\u300d<\/b>\u3092\u62bc\u3057\u3066\u3001\u4efb\u610f\u306e\u8272\u3092\u9078\u629e\u3057\u3066<b>\u300cOK\u300d<\/b>\u3092\u62bc\u3057\u307e\u3059\u3002\u6b21\u306e\u753b\u9762\u3082<b>\u300cOK\u300d<\/b>\u3002<\/div>\n<div><span class=\"mt-enclosure mt-enclosure-image\" style=\"display: inline;\"><a href=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/images\/today4.jpg\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"mt-image-none\" src=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/assets_c\/2011\/01\/today4-thumb-350x284-2169.jpg\" alt=\"today4.jpg\" width=\"350\" height=\"284\" \/><\/a><\/span><\/div>\n<div><\/div>\n<div>\u73fe\u5728\u306e\u65e5\u4ed8\u306e\u884c\uff081\u670826\u65e5\uff09\u306b\u8272\u304c\u4ed8\u304f\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/div>\n<div><span class=\"mt-enclosure mt-enclosure-image\" style=\"display: inline;\"><a href=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/images\/today7.jpg\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"mt-image-none\" src=\"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/assets_c\/2011\/01\/today7-thumb-400x203-2175.jpg\" alt=\"today7.jpg\" width=\"400\" height=\"203\" \/><\/a><\/span><\/div>\n<div><\/div>\n<div>\u6bce\u65e5\u958b\u304f\u3001\u5165\u529b\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308c\u3070\u3001\u3053\u3093\u306a\u98a8\u306b\u8272\u304c\u4ed8\u304f\u3068\u4fbf\u5229\u3067\u3059\u3088\u306d\u3002<\/div>\n<div><\/div>\n<div>\u305c\u3072\u3001\u3054\u6d3b\u7528\u304f\u3060\u3055\u3044\u3002<\/div>\n<div>\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6\u25c6<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u4eca\u65e5\u306f\u4f1a\u793e\u3067\u30bb\u30df\u30ca\u30fc\u3092\u958b\u50ac\u3057\u3066\u3044\u307e\u3059\u3002 \u30e2\u30ab\u306f\u4eca\u65e5\u306f\u53d7\u4ed8\u3092\u62c5\u5f53\u3055\u305b\u3066\u3044\u305f\u3060\u3044\u3066\u304a\u308a\u307e\u3059\uff3e\uff3e \u305f\u304f\u3055\u3093\u306e\u65b9\u304c\u4eca\u65e5\u306e\u30bb\u30df\u30ca\u30fc\u306b\u5fdc\u52df\u3057\u3066\u304f\u3060\u3055\u308a\u3001 \u5b9a\u54e1\u3044\u3063\u3071\u3044\u306b\u306a\u308a\u307e\u3057\u305f\uff01 \u524d\u65e5\u3001\u30c6\u30fc\u30d6\u30eb\u3092\u62ed\u3044\u305f\u308a\u3001\u914d\u7f6e\u3092\u6574\u3048\u305f\u308a\u3001 \u6c17\u6301\u3061 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":2533,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[8],"tags":[],"class_list":["post-155","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-8"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-content\/uploads\/2025\/07\/newcom_cafecs4-thumb-100x121-26.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/comments?post=155"}],"version-history":[{"count":3,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/155\/revisions"}],"predecessor-version":[{"id":3566,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/posts\/155\/revisions\/3566"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/media\/2533"}],"wp:attachment":[{"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/media?parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/categories?post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.newcom07.jp\/EXCEL-database\/blog\/excel_coffee_break\/wp-json\/wp\/v2\/tags?post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}