Smart Cell Calendar

Cell Specific Smart Date Validation

Click My View Smart Cell Calendar / Smart Date Validation

 

Helping every-day business users of Excel to work faster, more efficiently and increase the capabilities of their spreadsheets. Imagine having greatly reduced errors in dates and saving the confusion and waste of time spent rectifying the issues caused by that error. 

The Smart Cell Calendar is automatic and can be customised for each date cell, to ensure that key dates are accurate, such as a delivery date or a settlement date which must always fall on a real working day - e.g. avoiding Good Friday, Easter Monday, etc.

 

In just moments, you can ensure that only real working days or weekdays can be entered into a specific cell. Without formulas!  Complex rules can be applied too. And the User Manual contains several examples to guide you.

Using the Smart Calendar is fast too!  Selection of days, months and years can be just a click or two, plus options for drop-down lists and scrolling.

 

Accurate entry of dates saves time by avoiding accidental mistakes and downstream confusion and time to rectify them.

All Click My View tools are specially designed to help business users of Excel improve efficiency and productivity. They are for people who want to complete their work in minimum time, with minimum effort, ideally for it to be automated or just require a click. Smart Forms work straight away, with little or no time to set up and no technical skills are needed.

 

Smart Date Calendar With Cell-Specific Date Validation 

 

The primary objectives are: fast and accurate entry of dates, without sacrificing speed of entry or risking invalid or incorrectly typed dates.

 

Designed to ensure high-quality data entry:

 

  • Easily ensures dates are always valid workdays

  • Stops entry of invalid dates (numbers, transposition, format)

  • Visual calendar helps identify days weekdays vs weekends

  • Easily restricts entry to working days, avoiding holidays

  • Clear error messages that identify any problems

 

Designed for fast entry of dates:

 

  • Click the Today button to select today

  • Click a day to select the date within the current month

  • Use the scroll buttons at the top to move the month up or down

  • Click on the Month or Year for a drop downs that you then click

  • If you don’t need to change the date, use Tab or Arrows to move on

 

Designed for fast navigation to next cell:

 

  • Enter Key -  go down to next visible row

  • Tab key - go right to the next visible column

  • Arrow keys – go left, right, up or down to the next visible cell

  • OK button – using your default Excel cursor movement it selects
    he next cell (to go right or to go down)

 

Visual guides aiding correct date selection:

 

  • There are clear titles above the columns

  • Weekdays and weekend days have different colors 

  • Week number is displayed alongside each date row

  • Month Name is displayed in full in the heading

  • Year is boldly displayed in the heading

  • Selected date is boldly displayed in red (in local format)

​​

 

Other keys:

  • Delete key - deletes cell content and exits

  • Escape key – exits leaving date unchanged

 

 

SMART FORMS Subscription 

 

Pack Starts From

$2 per Week!

subscribe-2580606_1920.png

I'm a paragraph. Click here to add your own text and edit me. It's easy.

Examples of Fast Selection Of Month and Year

Ensures Data Quality For Dates

 

Users are prevented from selecting invalid dates is accomplished by adding Date Validation to the cell. Below is an example that sets the date range as valid for any date within 2018. (Note: Date format automatically defaults to local region date format) 

 

Examples Of ​Attempted Invalid Date Selection

Examples Of Default Smart Cell Calendar & Default Error Messages

 

 

Advanced Date Validation - Multiple Criteria

Working Days - Weekdays - Holidays - Other non working days

Detailed User Manual And Comprehensive Example Workbook Included

No Setup Is Required To Get Started

 

 

Setup For Work Days And Week Days Takes Moments

Optionally add more validation rules to restrict date range.

Smart Forms Control Menu

   Overall control of the Smart Forms is through a ribbon menu, entitled CMV

 

  • About: Displays a message box containing information about the software version

  • Start Functions: Starts all functions – checks the licence and awakes the functions.

  • Stop Functions: Stops all functions – puts them to sleep.

  • Backup File: Creates a backup of your workbook with a time-stamped file name.

  • Sheets: Opens the Sheets window for fast navigation to hidden sheets.

  • Menus On - Off: Enables / disables automatic display of menus.

  • Lists On - Off: Enables / disables automatic display of Smart Lists / Dependant Lists.

  • Calendar On - Off: Enables / disables automatic display of cell calendars.

  • Smart Text On - Off: Enables / disables automatic display of text editing windows.

 

Please join our mailing list for news and updates

Smart Forms Overview Header Play.png

Smart Forms Productivity Tools


   Helping every-day Excel users to work faster, more efficiently and increase spreadsheet capabilities.

 

  • Smart List - automatically replaces Excel drop downs, searchable, multi-column display, multi-selection. With numerous options, which includes viewing photos, documents, web pages and enabling Smart Dependency Lists – with a new approach, that is much faster and easier than traditional methods
     

  • Smart Cell Calendar – no more blindly typing dates – with fast selection of real working days, etc.
     
  • Smart Dependency List – a new, much faster and easier method, than traditional methods
     

  • Smart Text Edit – an automatic window for cell text editing - with basic formatting, real tabs, bullets, etc.
     

  • Smart Menu -  intelligent menu - go to any cell - auto opens workbooks, sheets and runs macros
     

  • Smart Sheets – click to go to any sheet - hide/unhide individual sheets or all sheets with just a click

 

 

This is a short overview of Smart Forms​

"Smart Forms save me time!"

Customer Satisfaction Is Important To Us
We believe in the effectiveness and quality of our products and are confident they will save you time and ease your workload.
 
If for any reason you are not satisfied within 30 days, we will happily return your money.
Guaranteed!

 

Smart Forms Pack Inclusions

 

  • Smart Lists – replaces Excel drop downs, searchable, multi-column display, multi-selection. With numerous options, which includes enabling Smart Dependency Lists – which is a new approach, much faster and easier than traditional methods
     

  • Smart Text Editor – for reading & editing text - with basic formatting, real tabs, bullets, etc.
     

  • Smart Cell Calendar – no more blindly typing dates – fast selection of the day, month & year
     

  • Smart Menu -  intelligent menu - click to open workbooks, unhide sheets & cells, run macros
     

  • Smart Sheets – click to go to any sheet, plus click for fast hiding / unhiding of sheets
     

  • Free point release updates, support, User Manual, Examples workbook, Access to all Videos

 

 

Plus a Free AddIn for Cell & Sheet Magnification!

 

 

 

 

 

 

 

 

SMART FORMS Subscription 

 

Pack Starts From

$2 per Week!

subscribe-2580606_1920.png
Sunshine Solutions Pty Ltd (ABN 30 124 423 552)
34 Balemo St, Minyama, Queensland Australia 4575
Email info@sunshinesolutions.com.au
  • YouTube Social  Icon
  • Facebook Social Icon
  • Twitter Social Icon