Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for calcing dates
Hiya,
The spreadsheet I need function help on is to be used to flag end dates for plant hire. We need to know when a piece of plant is over 2 weeks on hire to keep track of where stuff is and what is available. I have used the following: =IF(ISBLANK(B2),TODAY()-A2,"") this gives number of days from start of hire and we can put in conditional formatting to flag up after X no. of days. where b2 = booked until date and a2 = start of hire Problem is that there is another field that indicates actual hire end date and I also need to use this so that if c2 = actual end of hire then the formula cals no of days actual hire. Hope this makes sense! Many thanks -- Pandora |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date formula for extracting unique dates | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula including dates | Excel Worksheet Functions | |||
How do I format dates accessed by a formula | Excel Discussion (Misc queries) |