| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula HELP !!
Thanks a lot Barb, Great stuff.
Regards, Mark "Barb Reinhardt" wrote: Format it as NUMBER. "santaviga" wrote: Hi, Sorry this is returning a date and time in 1900 I need it to return data 1 WEEK or 2 WEEK or 3 WEEK depening on the x's in the information according to week commencing dates. Mark "Barb Reinhardt" wrote: Let's say that your dates are in column 1. Let's also say that Bill's information is in column 3 (specifically cells B3:H3) Try this formula: =INT(TODAY()-INDEX($1:$1,1,MATCH("x",A3:H3)))/7 "santaviga" wrote: Hi Need Help with a complicated formula, dont knoe if its possible or not, here it goes, I have the following cells laid out. NAME A B C D E F G Above are all dates of beginning of weeks Bill X x x Ady x Tom x I need a formula that will return data of arrears paymeny e.g in weeks (1week) (2weeks) and so on, so Ady and Tom would return data 2 weeks, is this possible taking the current date for a reference? Any Help??? Thanks a lot |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Hybrid Mode
