| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fromula
Would like to set up a formula that returns a value if the date is 12/31/??
and another value if it is any other day of the year? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fromula
Hi
One way =IF(TEXT(A1,"MMDD")="1231","yes","no") Substitute whatever you wish for "yes" and "no" -- Regards Roger Govier "tboy" wrote in message ... Would like to set up a formula that returns a value if the date is 12/31/?? and another value if it is any other day of the year? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fromula
=IF((MONTH(TODAY())=12)*(DAY(TODAY())=31),1,0)
will return 1 on Dec 31 will return 0 otherwise -- Gary''s Student - gsnu200725 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Fromula | Excel Worksheet Functions | |||
| How can I write a fromula to subtract 1/4 from 1/2 and so on? | Excel Discussion (Misc queries) | |||
| how do i lock a cell with a fromula? | Excel Discussion (Misc queries) | |||
| Corporated into the same fromula please. | Excel Worksheet Functions | |||
| Need a fromula | Excel Discussion (Misc queries) | |||
Linear Mode
