|
| 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 |
|
#1
November 8th, 2007, 04:03 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formula
Take 2..
I am trying to get a formula that will assign a numeric value for a each year past "TODAY". The TODAY date needs to change every day. Today to 365days=1; 366 days to 730=2; 730 to 1095=3; 1095+ =4 
|
|
#2
November 8th, 2007, 04:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Formula
More info would have been helpful. Is this what you want.
=INT((TODAY()-H20)/365.25) -- Don Guillett Microsoft MVP Excel SalesAid Software "Matt" wrote in message ... Take 2.. I am trying to get a formula that will assign a numeric value for a each year past "TODAY". The TODAY date needs to change every day. Today to 365days=1; 366 days to 730=2; 730 to 1095=3; 1095+ =4
|
|
#3
November 8th, 2007, 04:24 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Formula
One way:
If you're not concerned about leap years: A1: date B1: =INT((A1-TODAY()-1)/365)+1 or if your max is really 4: B1: =MIN(4, INT((A1-TODAY()-1)/365)+1) If you want to take leap years into account: B1: =DATEDIF(TODAY(),A1-1,"y")+1 In article , Matt wrote: I am trying to get a formula that will assign a numeric value for a each year past "TODAY". The TODAY date needs to change every day. Today to 365days=1; 366 days to 730=2; 730 to 1095=3; 1095+ =4
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
