|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#21
August 14th, 2007, 04:13 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date + 365 in New Column
"Sandy Mann" wrote...
"Harlan Grove" wrote in message oups.com... =F2+366-(DAY(F2)DAY(F2+366))+AND(TEXT($F$2,"mmdd")="0229 ", MOD(YEAR(F2+366-(DAY(F2)DAY(F2+366))),4)=0, OR(MOD(YEAR(F2)+1,100)0,MOD(YEAR(F2)+1,400)=0 )) Congratulations! it works for all dates. I knew you could do it if I pushed you g .... I deserve that this time. Figures I'd come up with the simple approach now that I finally managed to get the complex approach working. =F2+366-(DAY(F$2)DAY(F2+366)) [for filling down] =F2+366-(DAY($F2)DAY(F2+366)) [for filling right] So why didn't you think of that before me? 
|
|
#22
August 14th, 2007, 04:39 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date + 365 in New Column
"Harlan Grove" wrote in message
... So why didn't you think of that before me? Harlan you're not developing a sense of humour are you? g -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
