Jinshan WPS Table How to make the countdown card

Today is November 30, from the Spring Festival New Year's Day small holiday still has one months, and the spring Festival less than 60 days, I believe many netizens began to countdown. Today, small compilation of the use of Jinshan WPS table to make the countdown card method, let the countdown card to remind themselves that the festival in a day close, that feeling is not very cool? Say not much, start to explain it!

① in cell A1, set the current date, enter the formula "=today ()",

② set the date of 2009 lunar in C1 Cell, that is, 2009-1-26

③ the number of days to set the countdown in the B1 cell,

Method One: Subtract two dates, i.e. B1 =c1-a1

Method Two: From the New Year date for Connaught Dry Days Countdown (set 62 days)

Input formula: "=if (c1-a1" 63,c1-a1, "") "

④ in order to be beautiful, set the A1 cell format to "Today is November 26, 2008 away from the new Year" as Pictured:

⑤ customization: font, color, font size: Figure:

Set the B1 cell format to "62 days", custom font, color, font size

⑥ to hide the C column.