After a year of busy finally have time to play again. However, every day to look at the countdown to the last of this period of time is really troublesome, then, use the WPS form to do a countdown. Say not much, start:
① 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)
Enter 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, the final effect, as shown in figure:
Form making