Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
70
Views
Topic starter
How to Auto set date as below in column A
Sat 19 Oct 2019 | 9:52 AM | 14.2 | Before Breakfast |
Sat 19 Oct 2019 | 2:47 PM | 5.1 | Before Lunch |
Sat 19 Oct 2019 | 6:35 PM | 15.3 | Before Dinner |
Sun 20 Oct 2019 | 11:30 AM | 14.4 | Before Breakfast |
Sun 20 Oct 2019 | 1:16 PM | 15.8 | Before Lunch |
Sun 20 Oct 2019 | Before Dinner | ||
Mon 21 Oct 2019 | 5:06 AM | 13.0 | Before Breakfast |
Mon 21 Oct 2019 | Before Lunch | ||
Mon 21 Oct 2019 | 5:52 PM | 13.1 | Before Dinner |
Tue 22 Oct 2019 | 5:11 AM | 13.8 | Before Breakfast |
Tue 22 Oct 2019 | 12:57 PM | 14.0 | Before Lunch |
Tue 22 Oct 2019 | 8:07 PM | 11.3 | Before Dinner |
Wed 23 Oct 2019 | 7:57 AM | 11.8 | Before Breakfast |
Wed 23 Oct 2019 | 9:42 AM | 9.0 | Before Lunch |
Wed 23 Oct 2019 | Before Dinner | ||
Thu 24 Oct 2019 | 9:46 AM | 9.0 | Before Breakfast |
Thu 24 Oct 2019 | 1:24 PM | 10.5 | Before Lunch |
Thu 24 Oct 2019 | Before Dinner |
Posted : 28/10/2019 7:55 pm
Hi Malcolm,
Welcome to our forum!
You can use this formula in the first cell and then copy down:
=INT((ROW(E1)-1)/3)+DATE(2019,10,19)
Mynda
Posted : 29/10/2019 8:12 am