Alter of Excel cell
Forum Sponsor
Top Posters
Soheil Barekat
4 posts
Luis Jr Ngade
6 posts
Ben Welsher
1 posts
Rohan Dashputre
0 posts
AMECHI ANAKWENZE
2 posts
Jayaprakash Sekar
1 posts
arash.karmand
0 posts
James Williams
74 posts
Vahidazimi01
0 posts
David Smith
4 posts
Many Thanks zhang
keep in tuch
you need some formula,
cell A1 = 11.6 then
year: int(a1)
month: int(mod(a1*365,365)/30)
day:: int(mod(a1*365,30))
you can input the following formula in Cell B1
=int(a1)&"y:"&int(mod(a1*365,365)/30)&"m:"&int(mod(a1*365,30))&"d"
But the result is not 100% acurate, as the caculation is based on 365days/year and 30days/month. Only when you have the start date and finish date then you can get the acurate result
Why do you need this?
Excels calcualtions on time ar based on days.
Why cant you just use days?
Svein