始める無料で始める

ISDATE function

OK, so you are a payroll person again, but we're going to switch a few things up to keep you on your toes.

We are going to start out with data that has those pesky hand typed dates again.

This payroll needs to be perfect, so let's first check the dates to be sure that they're valid.

この演習はコースの一部です

Google スプレッドシートの条件付き書式

コースを見る

演習の手順

  • Add a conditional formatting rule using a custom formula and the ISDATE function to highlights the valid dates with the Default green background.

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する