| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Up Calendar To Account For Leap Years
Hello All
Got a calendar all on one worksheet. It puts each date in like this: CELL A1: =DATE(year, 1,1), A2: =A1+1, A3: =A2+1, etc. I want to print it out with each month on a separate piece of paper. I can't put the page breaks in manually because in leap years I'll end up with 29 Feb on the top of the March page, 31 Mar on the top of the April page, etc, etc. How can I get the page breaks to go in so that they'll always separate the months right for every year? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average between dates considering leap years. | Excel Discussion (Misc queries) | |||
| Does the Networkdays function allow for leap years | Excel Worksheet Functions | |||
| How does Excel allow for leap years? | Excel Worksheet Functions | |||
| Non Leap Years I want to show 28, leap years show 29 in an"IF" | Excel Worksheet Functions | |||
| DATEDIF and leap years | New Users to Excel | |||
Threaded Mode
