| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculate 18 monts from a date
Hi I need to calculate from une date if 18 monts has past, if is false put a
"X" on if is true livet in blank (no 0 ) ex Kevin start on 06 mai 2007 still no 18 monts = "X" Tony start on 03 fev 2007 hi pas 18 monts = " " tanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
calculate 18 monts from a date
Hi
=IF(DATEDIF(A11,TODAY(),"m")<18,"X","") -- Regards Roger Govier "Centauro" wrote in message ... Hi I need to calculate from une date if 18 monts has past, if is false put a "X" on if is true livet in blank (no 0 ) ex Kevin start on 06 mai 2007 still no 18 monts = "X" Tony start on 03 fev 2007 hi pas 18 monts = " " tanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
calculate 18 monts from a date
Thanks but what if I want to compare to another date in B9 for ex
i tray =IF(DATEDIF(A11,B9,"m")<18,"X","") and gime a error Tks "Roger Govier" wrote: Hi =IF(DATEDIF(A11,TODAY(),"m")<18,"X","") -- Regards Roger Govier |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
calculate 18 monts from a date
Start date first so A11 must be the earlier date.
-- Regards, Peo Sjoblom "Centauro" wrote in message ... Thanks but what if I want to compare to another date in B9 for ex i tray =IF(DATEDIF(A11,B9,"m")<18,"X","") and gime a error Tks "Roger Govier" wrote: Hi =IF(DATEDIF(A11,TODAY(),"m")<18,"X","") -- Regards Roger Govier |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
calculate 18 monts from a date
Yes A11 will be always the earlier date that is way I need to calculate if 18
months has been past "Peo Sjoblom" wrote: Start date first so A11 must be the earlier date. -- Regards, Peo Sjoblom "Centauro" wrote in message ... Thanks but what if I want to compare to another date in B9 for ex i tray =IF(DATEDIF(A11,B9,"m")<18,"X","") and gime a error Tks "Roger Govier" wrote: Hi =IF(DATEDIF(A11,TODAY(),"m")<18,"X","") -- Regards Roger Govier |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
calculate 18 monts from a date
So what did you put in B9 and what kind of error did you get?
-- Regards, Peo Sjoblom "Centauro" wrote in message ... Yes A11 will be always the earlier date that is way I need to calculate if 18 months has been past "Peo Sjoblom" wrote: Start date first so A11 must be the earlier date. -- Regards, Peo Sjoblom "Centauro" wrote in message ... Thanks but what if I want to compare to another date in B9 for ex i tray =IF(DATEDIF(A11,B9,"m")<18,"X","") and gime a error Tks "Roger Govier" wrote: Hi =IF(DATEDIF(A11,TODAY(),"m")<18,"X","") -- Regards Roger Govier |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to calculate end date using order date and lead time variab | Excel Worksheet Functions | |||
| Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
| formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| Calculate month-end date from date in adjacent cell? | Excel Worksheet Functions | |||
Linear Mode
