How do you take a list of dates and switch to calendar view?

Charlene Biggerstaff

I know about the  calener button! It does not work with a list of dates in one cell, for expample: Sept 3, 4, 7, 12 when listed in a cell will not conver to the calender.

 

thank you

Charlene

JamesR

Charlene,

This is not possible.  All dates must be in thier own cell and either a single colum or two columns for a range of date (From - To).

Each date must also be in a date type column and eneterd in a recognised date format.

KrisWalsh

I suggest you have a row for each date to show them on the calendar calendar.

Sample Calendar