Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I have a column for dates, starting with the first day of the year. I only have to input the first day on cell A@ (say 01/01/06) and the all the days of the years will be display in the same column (I wrote the simple formula =A2+1). Now the next leap year is 2008 and i don't want to have to copy the last row to add the extra day, I want excel to display the last row of the date column if it's a leap year and not to display it when is not. What should I do? Thank you Thalia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Month Year Date Format | Excel Worksheet Functions | |||
Need totals of values that fall within a given year | Excel Worksheet Functions | |||
Weeknum Year by Year Compare | Charts and Charting in Excel | |||
Another question regarding Dates.. | Excel Discussion (Misc queries) |