PDA

View Full Version : Date formula required



Sambo24
10-12-2009, 12:54 AM
I need a need a formula to indicate a persons time in post.

I have the start date A1 = 01-Jan-1980

B1 = time in post to todays date. using the 'now' & 'dateif' function maybe?

Then I need to be able to fill this formula down the sheet.

Many Thanks in advance.

Sambo

Bob Phillips
10-12-2009, 03:38 AM
Is this just the number of days?

=B1-A1

Sambo24
10-12-2009, 03:41 AM
Thanks for your response but I've worked it out now. I neded it displayed in yy&mm

solution: =DATEDIF(A1,B1,"y")&" Years & "&DATEDIF(A1,B1,"ym")&" m"

Thanks

Bob Phillips
10-12-2009, 03:42 AM
Thanks for your response but I've worked it out now. I neded it displayed in yy&mm

It helps when we get all the information!

Sambo24
10-12-2009, 03:44 AM
I imagine it would. Next time I won't bother telling you another site solved it with the same info.

Have a nice day!