|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
February 13th, 2004, 02:05 PM
|
|||
|
|||
MS Excel question
I'm trying to turn a date into Months using a formula... I was wondering if anyone could help me
ie: 01-Mar-97 = 82 Months (from that date to now) is there some kind of formula that I can use to do this?? Thanks 
|
|
#2
February 17th, 2004, 11:26 AM
|
||||
|
||||
|
Simple solution
Use the following function into one b3 DAYS360(B1,B2)/30 where b1 cell will have 01-mar-97 b2 cell will have currentdate There are more elegant solutions by using functions like datediff etc for which you have to make reference to office object library from vb module and so on.
__________________
V.Subramanian
|
|
#3
May 17th, 2006, 08:28 PM
|
|||
|
|||
|
Hello Supersubra,
Is there any Excel Master on this forum? I need some urgent help. Here's my problem: There are Two columns, the first represents product category (say products soap, brush, & comb), while the next column represents the serial nos. (say 1 to 10). Each product can have serial nos 1 to 10, but once a combination is selected, it should not be repeated; for instance, if I select Soap+1 in a cell somewhere, the sheet should automatically reject the same entry elsewhere (i am going to use Data-Validation-List for this purpose). The same should be the cas with Brush & Comb... I tried using help, but to no avail. Can you suggest a way in MS Excel in which it can be solved?? Your reply would be greatly appreciated. regs, Indiason
|
|
| Viewing: ASP Free Forums > Other > Programming Help > MS Excel question |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
