Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I WANT TO CREATE A FORMULA USING DATES
I have dates in 3 seperate colums for 3 seperate tasks on Sheet 1. On Sheet 2
with in the same file i have a colomn that has either nothing or an X in it when a specific task is complete. the three date colomn's aU5, V5, W5. the other column is H5 on the other sheet. I want to create a formula that when all 4 variables are entered, it puts the date when all tasks were completed in cell T5 on sheet one. what i have come up with so far is this: =IF(AND(U5=dd-mmm-yy,AND(V5=dd-mmm-yy,AND(W5=dd-mmm-yy,AND('sheet2'!H5=X)))),"TODAY(dd-mmm-yy)","" any help would be greatly appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create formula to calc difference in dates? | Excel Discussion (Misc queries) | |||
Need to create a formula that counts dates | Excel Discussion (Misc queries) | |||
HOW CREATE FORMULA TO ADD THE COLUMN CELLS THAT CONTAINING DATES | Excel Worksheet Functions | |||
Formula to Create Consecutive #s for Non-Linear Dates | Excel Worksheet Functions | |||
How can I create a formula to locate data between two dates? | Excel Worksheet Functions |