Take this simple example:
m = (1:3)’;
dates = datetime(2025,m,15);
tt = timetable(dates,m);
writetimetable(tt,’tt.xlsx’)
tt is a 3×1 timetable with dates but no times 00:00:
dates m
___________ _
15-Jan-2025 1
15-Feb-2025 2
15-Mar-2025 3

But the resulting excel sheet tt.xlsx includes the times 00:00:
dates m
1/15/25 00:00 1
2/15/25 00:00 2
3/15/25 00:00 3

How can I make writetimetable create an excel sheet with dates but no times 00:00?Take this simple example:
m = (1:3)’;
dates = datetime(2025,m,15);
tt = timetable(dates,m);
writetimetable(tt,’tt.xlsx’)
tt is a 3×1 timetable with dates but no times 00:00:
dates m
___________ _
15-Jan-2025 1
15-Feb-2025 2
15-Mar-2025 3

But the resulting excel sheet tt.xlsx includes the times 00:00:
dates m
1/15/25 00:00 1
2/15/25 00:00 2
3/15/25 00:00 3

How can I make writetimetable create an excel sheet with dates but no times 00:00? Take this simple example:
m = (1:3)’;
dates = datetime(2025,m,15);
tt = timetable(dates,m);
writetimetable(tt,’tt.xlsx’)
tt is a 3×1 timetable with dates but no times 00:00:
dates m
___________ _
15-Jan-2025 1
15-Feb-2025 2
15-Mar-2025 3

But the resulting excel sheet tt.xlsx includes the times 00:00:
dates m
1/15/25 00:00 1
2/15/25 00:00 2
3/15/25 00:00 3

How can I make writetimetable create an excel sheet with dates but no times 00:00? writetimetable excel, dates no times MATLAB Answers — New Questions

​