***robotics date macro - 1***

[rohitw2]

Hi, I need a macro/vba code which can calculate the Age calculation. I mean it must calculate current date minus the different pay date in column d to column c. As i have to do it manaually on daily basis so i want to do it automatically the moment i paste the new pay dates in column d.

Please Help me!!!

 

[Ruddles]

I'm not completely sure I understand you. Would you care to give us an example of the data in columns C and D, and what you want the result to be for a given date?

Hopefully you're aware that dates just represent the number of days since 1/1/1900 - so for example today is 42790 - and you can do simple arithmetic with them such as adding a number of days to a date to find a date in the future or subtracting one date from another to find the number of days between them?

 

[rohitw2]

Suppose i have 3 column b, c and d. I have different dates in column b which i have manually added. what i want is, a macro should update the today's date in column c and do the age calculation(Today's date minus the other date i have in column b) in column d automatically.

 

[mole999]

say you put in A1 = Now() that will always update to the latest value,, then in B1 is the date you are interested in, then in C1 your output which is =$A$1-B1 and format as you wish to see . You can drag C1 down, and A1 is always your reference

 

[MARK858]

Why do you need VBA rather than a formula

Excel Workbook
	B	C	D
1	03/09/1972	25/03/2017	16274 Days
2	03/09/1972	25/03/2017	534 Months
3	03/09/1972	25/03/2017	44 Years
4	03/09/1972	25/03/2017	44 Years, 6 Months, 22 Days
Sheet1

 

[rohitw2]

Thanks for this. But i want this in coding rather than using the excel formula in a sheet for at least calculating the age in column d.

 

[rohitw2]

[FONT=&quot]Thanks for this. I know to do this manually in excel but [/FONT][FONT=&quot]i[/FONT][FONT=&quot] want this in coding rather than using the excel formula in a sheet for [/FONT][FONT=&quot]at least[/FONT][FONT=&quot] calculating the age in column d.[/FONT]

 

[MARK858]

[FONT="]Thanks for this. I know to do this manually in excel but [/FONT][FONT="]i[/FONT][FONT="] want this in coding rather than using the excel formula in a sheet for [/FONT][FONT="]at least[/FONT][FONT="] calculating the age in column d.[/FONT]

Hmm, you still haven't stated why you want it in code but...

To start with a macro doesn't automatically update, it needs something to trigger it and so you need to tell us what is going to trigger it i.e. a selection change, a worksheet change, the workbook opening, a double click etc.

You also need to state how you want the age to appear.

Btw the formulas do automatically update.

 

[Ruddles]

It really would help if you could give us an example of the dates in columns B, C and D, and what you want the result to be for a given date.

 

[mole999]

or, as you can do formulas, why not do that and then record with the macro recorder