Japanese

Calendar using Excel

Creating calendar is proposed here though there may exist a more simple method.

Figure 1.

A calendar automatically appears if you enter year and month. As the cells b3, c3, b10, and c10 are visually obstructive; alteration of font color of these cells to white may be the simple method.

(note) 『 =weekday("2013/3/1") 』returns a number of week of the specified date (March 1, 2013) …(this date is Friday i.e. 6 days count from Sunday, therefore the WEEKDAY-function returns 6 )

『 =weekday("2010/2/29") 』 returns #VALUE! error because of absence of such date, but 『 =iserror(weekday("2010/2/29")) 』 gives TRUE.

You can get a sample of above calendar if you copy the subsequent data to your Excel Sheet. The string "sample" must be set in A1 cell.

 
sample
2013 year 3 month
=B2&"/"&D2&"/" =WEEKDAY(B3&"1")
Sun Mon Tue Wed Thu Fri Sat
=IF(C3=1,1,"") =IF(B5="",IF($C$3=2,1,""),B5+1) =IF(C5="",IF($C$3=3,1,""),C5+1) =IF(D5="",IF($C$3=4,1,""),D5+1) =IF(E5="",IF($C$3=5,1,""),E5+1) =IF(F5="",IF($C$3=6,1,""),F5+1) =IF(G5="",1,G5+1)
=H5+1 =B6+1 =C6+1 =D6+1 =E6+1 =F6+1 =G6+1
=B6+7 =C6+7 =D6+7 =E6+7 =F6+7 =G6+7 =H6+7
=B7+7 =C7+7 =D7+7 =E7+7 =F7+7 =G7+7 =H7+7
=IF(ISERROR(WEEKDAY($B$3&B8+7)), "",B8+7&IF(B10="","","/"&B10)) =IF(ISERROR(WEEKDAY($B$3&C8+7)), "",C8+7&IF(C10="","","/"&C10)) =IF(ISERROR(WEEKDAY($B$3&D8+7)), "",D8+7) =IF(ISERROR(WEEKDAY($B$3&E8+7)), "",E8+7) =IF(ISERROR(WEEKDAY($B$3&F8+7)), "",F8+7) =IF(ISERROR(WEEKDAY($B$3&G8+7)), "",G8+7) =IF(ISERROR(WEEKDAY($B$3&H8+7)), "",H8+7)
=IF(ISERROR(WEEKDAY($B$3&B8+14)), "",B8+14) =IF(ISERROR(WEEKDAY($B$3&C8+14)), "",C8+14)

このサイトで扱った項目