Exploratory Hour #132 - Excelの日付データ（44197）と記号と欠損値が混在している列を正しい日付型の列にしたい

Confirmation

Do you want to subscribe to the notification email?

Once subscribed, notification emails will be sent to your registered email address when the insight is republished or refreshed by the scheduling.

Schedule Frequency

Not Scheduled

Markdown Text

Embed Note

<iframe 
  src="https://exploratory.io/note/GMq1Qom5tS/Exploratory-Hour-132-Excel-44197-dsj8RNM3WC?embed=true"
  frameborder="0"
  width="100%"
  height="100%"
  >
</iframe>

Exploratory Hour #132 - Excelの日付データ（44197）と記号と欠損値が混在している列を正しい日付型の列にしたい

Updated

573 10

Project Information
Project Name
Exploratory Hour
Note Name
Exploratory Hour #132 - Excelの日付データ（44197）と記号と欠損値が混在している列を正しい日付型の列にしたい
Description

Excelの日付データと記号を正しい日付型のデータに変換する方法を紹介しています。
Created By
Takato Shiroto
Created Date

Updated Date

Desktop Version
6.7.0.1
Schedule
Scheduling is not supported because:
No Data Source to Refresh
Last Refresh Log (Schedule)
Status

Start Time
Finish Time
Time Elapsed
Processed Data Size
Processed # of Rows

Open Without Header
Embedding Code
Sign In

Exploratory Hour #132 - Excelの日付データ（44197）と記号と欠損値が混在している列を正しい日付型の列にしたい
Takato Shiroto
Refreshed:
573
Exploratoryhour
Team Exploratory
Japanese
How-to
Data Wrangling
Case_when
Coalesce
Excel
Date
Na
Open Without Header
Sign In

Exploratoryhour

Team Exploratory

Terms
Privacy
Security Policy
Contact Us

Contact Us

© 2025 Exploratory, Inc.

Sign Up

Thank you for registering! We will send you an email once your account is ready.

Sorry, our system had an error. Please send email to support@exploratory.io.

A user with this email address already exists. You can login from here. If you forgot your password, you can reset your password here.

Please enter valid email address and try again.

Thanks for your interest! Please tell us a little bit more about you.

EmailYour primary OSOrganization (optional)Your favorite data analysis tools (optional)

Enter a Note Name

Loading the Note Editor...