Forum Discussion

Swbesse's avatar
Swbesse
Copper Contributor
May 01, 2022

How to take dates in exce table and make into Calendar view

Hello,

 

I am trying to get a calendar view in Excel from a table of dates... Please see attached file.. I have the basics for 1 row but need multiple rows to lookup... 2 different tabs

 

Tab 1 - table with dates

04-04-2205-04-22     06-04-22MICHAELLees Summit
10-04-2211-04-22     12-04-22MICHAELLees Summit
06-04-22      06-04-22MICHAELPoint Grey Beach House
15-04-22      15-04-22TREVYNMicrosoft Walls
10-05-22      10-05-22MICHAELDallas ISD
25-05-22      25-05-22TREVYNACM - RCMP
05-05-22      05-05-22TREVYNSullivan Heights
01-05-22      01-05-22MICHAELJackson Elementary
29-04-2230-04-22     30-04-22TREVYNCreekview Corporate
03-06-22      03-06-22TREVYNTWU School
10-06-22      10-06-22ChrisCamouson College
18-06-2219-06-22     19-06-22CHRISLaurel Street
12-04-22      12-04-22MICHAELSFU 
06-05-22      07-05-22TREVYNTWU School
07-05-22      07-05-22TREVYNBellevue
08-05-22      08-05-22KAYLALuther Court
09-05-22      09-05-22TREVYNTWU School
10-05-22      10-05-22TREVYNTWU School
11-05-22      11-05-22VICGeorgetown Discovery Center
12-05-22      12-05-22ChrisCamouson College
00-01-0001-01-0002-01-0003-01-0004-01-0005-01-0006-01-0010-01-0000.00
00-01-00      00-01-0000.00
00-01-00      00-01-0000.00

 

 

Calendar View

Month of:May 2022 2022-05-011   #VALUE!  44856    
                
SatSunMonTueWedThuFri         
30010203040506         
 MICHAEL - Jackson Elementary   TREVYN - Sullivan HeightsTREVYN - TWU School2 #NUM!9#NUM!#NUM!#NUM!815
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
07080910111213         
TREVYN - BellevueKAYLA - Luther CourtTREVYN - TWU SchoolMICHAEL - Dallas ISDVIC - Georgetown Discovery CenterChris - Camouson CollegeMICHAEL - Lees Summit  1617186202122
   TREVYN - TWU School     #NUM!#NUM!#NUM!19#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
14151617181920         
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
21222324252627         
    TREVYN - ACM - RCMP    #NUM!#NUM!#NUM!#NUM!7#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
28293031010203         
      TWU School - TWU School  #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!11
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
04050607080910         
      Chris - Camouson College  #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!12
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
         #NUM!#NUM!#NUM!#NUM!#NUM!#NUM!#NUM!
excel
No RepliesBe the first to reply

Resources