Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Help (Date)
I need help with the following:
Cell A1 has the start date Cell B1 has the estimted stop date Cell A4 has a date in it - the cells below each have an expense in them for that day. I would like to have a formula enter a 1 in cell A24 if the date in cell A1 is = the date in cell A1 and is <= the value in cell B1. If it is out of the date range between A1 & B1 then enter a "0" Thanks, Chance |
#2
|
|||
|
|||
try this assuming A4 is the date you are checking between date range
beginning in A1 and ending in B1 =IF(AND(A4=A1,A4<=B1),1,0) "Chance224" wrote: I need help with the following: Cell A1 has the start date Cell B1 has the estimted stop date Cell A4 has a date in it - the cells below each have an expense in them for that day. I would like to have a formula enter a 1 in cell A24 if the date in cell A1 is = the date in cell A1 and is <= the value in cell B1. If it is out of the date range between A1 & B1 then enter a "0" Thanks, Chance |
#3
|
|||
|
|||
I would like to have a formula enter a 1 in cell A24 if the date in cell
A1 is = the date in cell A1 and is <= the value in cell B1 Assuming that you meant ........cell B4 is =....... Try =(B4=A1)*(B4<=B1) -- HTH Sandy Replace@mailinator with @tiscali.co.uk "Chance224" wrote in message ... I need help with the following: Cell A1 has the start date Cell B1 has the estimted stop date Cell A4 has a date in it - the cells below each have an expense in them for that day. I would like to have a formula enter a 1 in cell A24 if the date in cell A1 is = the date in cell A1 and is <= the value in cell B1. If it is out of the date range between A1 & B1 then enter a "0" Thanks, Chance |
#4
|
|||
|
|||
Just another option:
= --(AND(A4=A1,A4<=B1)) -- Dana DeLouis Win XP & Office 2003 "Chance224" wrote in message ... I need help with the following: Cell A1 has the start date Cell B1 has the estimted stop date Cell A4 has a date in it - the cells below each have an expense in them for that day. I would like to have a formula enter a 1 in cell A24 if the date in cell A1 is = the date in cell A1 and is <= the value in cell B1. If it is out of the date range between A1 & B1 then enter a "0" Thanks, Chance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
addition to my date formula...required | Excel Worksheet Functions | |||
Excel formula with date constraints | Excel Discussion (Misc queries) | |||
Formula with date constraints | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |