開始使用免費開始

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.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習