| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trouble with formulas!!!
Hi there
I am trying to create a formula in excel 2003. If the date shown in cell K8 is before todays date, I want it to return a value of 0 and if the date shown is today or later I want it to return a value of 1 - can anyone please help??? Many thanks in advance Vikki |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trouble with formulas!!!
Use:
=if(k8<today(),0,1) "Vikki" wrote: Hi there I am trying to create a formula in excel 2003. If the date shown in cell K8 is before todays date, I want it to return a value of 0 and if the date shown is today or later I want it to return a value of 1 - can anyone please help??? Many thanks in advance Vikki |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trouble with formulas!!!
Dear Vikki
Try the below using TODAY() function =IF(K8<TODAY(),0,1) If this post helps click Yes --------------- Jacob Skaria "Vikki" wrote: Hi there I am trying to create a formula in excel 2003. If the date shown in cell K8 is before todays date, I want it to return a value of 0 and if the date shown is today or later I want it to return a value of 1 - can anyone please help??? Many thanks in advance Vikki |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trouble with formulas!!!
=IF(K8<TODAY(),0,1)
"Vikki" wrote: Hi there I am trying to create a formula in excel 2003. If the date shown in cell K8 is before todays date, I want it to return a value of 0 and if the date shown is today or later I want it to return a value of 1 - can anyone please help??? Many thanks in advance Vikki |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trouble with formulas!!!
Thank you that is perfect!!!
"Jacob Skaria" wrote: Dear Vikki Try the below using TODAY() function =IF(K8<TODAY(),0,1) If this post helps click Yes --------------- Jacob Skaria "Vikki" wrote: Hi there I am trying to create a formula in excel 2003. If the date shown in cell K8 is before todays date, I want it to return a value of 0 and if the date shown is today or later I want it to return a value of 1 - can anyone please help??? Many thanks in advance Vikki |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trouble with formulas!!!
Thank you that is perfect!!!
"chriswilko" wrote: Use: =if(k8<today(),0,1) "Vikki" wrote: Hi there I am trying to create a formula in excel 2003. If the date shown in cell K8 is before todays date, I want it to return a value of 0 and if the date shown is today or later I want it to return a value of 1 - can anyone please help??? Many thanks in advance Vikki |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trouble with formulas!!!
Thank you that is perfect!!!
"RonaldoOneNil" wrote: =IF(K8<TODAY(),0,1) "Vikki" wrote: Hi there I am trying to create a formula in excel 2003. If the date shown in cell K8 is before todays date, I want it to return a value of 0 and if the date shown is today or later I want it to return a value of 1 - can anyone please help??? Many thanks in advance Vikki |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trouble with formulas!!!
Another way:
=--(K8=TODAY()) Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Vikki" wrote in message ... Hi there I am trying to create a formula in excel 2003. If the date shown in cell K8 is before todays date, I want it to return a value of 0 and if the date shown is today or later I want it to return a value of 1 - can anyone please help??? Many thanks in advance Vikki |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HAVING TROUBLE KEEPING MY SPREADSHEET FORMULAS PERMANENT | Excel Discussion (Misc queries) | |||
| Trouble with DGET & VLOOKUP formulas | Excel Discussion (Misc queries) | |||
| TROUBLE COPYING AND PASTING FORMULAS | Excel Worksheet Functions | |||
| Trouble with formulas | Excel Discussion (Misc queries) | |||
| Trouble with Excel 2000 not calculating/performing formulas | Excel Worksheet Functions | |||
Linear Mode
