Thank you for sharing the video. I tried the Textjoin function, it works but it shows both the date (in numbers) with holiday. Not sure how to formulate the now. :(
In this calendar, the dates are built from a single formula, so the dates can't link to other cells. On my Contextures site, you can get a Excel holiday planner, and it has a calendar that shows daily items. www.contextures.com/Excel-Christmas-Planner.html
I have a calendar where you can add text, but no video for it yet. You can download it from my Contextures site - go to the Excel Event Calendar section on this page: www.contextures.com/excelcalendarformulas.html
What a great idea. Tori it was easy to follow and it was broken down into smaller steps. Wonderful job
Thank you, Patrick, and I'm glad you found the video helpful! Thanks for your encouraging comments!
This is perfect!! Thank you, I finally was able to get what I was looking for.
You're welcome, Elizabeth, and I'm glad the video had what you were looking for!
This was agreat help, thank you.
You're welcome, Richard, and thanks for your comment!
Hi, what if we want to then add events to the calendar? Or checkboxes with events that have been completed?
I've added an event calendar that you can download on this page on my Contextures site:
www.contextures.com/excelcalendarformulas.html
Thank you for sharing the video. I tried the Textjoin function, it works but it shows both the date (in numbers) with holiday. Not sure how to formulate the now. :(
Hi can we put a data like number of hours work on that date cell since it's small based from another cell or tables ? Thank you
In this calendar, the dates are built from a single formula, so the dates can't link to other cells. On my Contextures site, you can get a Excel holiday planner, and it has a calendar that shows daily items. www.contextures.com/Excel-Christmas-Planner.html
Hi can we add text in this calendar if so can you make a video please and thank you
I have a calendar where you can add text, but no video for it yet. You can download it from my Contextures site - go to the Excel Event Calendar section on this page: www.contextures.com/excelcalendarformulas.html
Is there a way to make the sequence formula skip columns?
Not that I know of! A different type of formula might do what you need
hi - is it possible to make a video for data entry Fields userform with scanned pdf display
Thanks for asking, but I don't have any examples for that. Perhaps you can find another video on that topic.
why does the textjoin formula wont work for me? :(
TEXTJOIN is one of the newer functions, available in Excel 365, Excel 2019 and later. Maybe you're using an earlier version?
Hi
Hi! It's nice to see you here again!