Formula to calculate age in days

[MarkDave]

Hi, I need a formula to calculate the age of an entry in excel between two days, or today of the end date filed is yet to be completed...any ideas?

 

[witsonjoyet]

Hi,

You can use Datedif formula. Say H7 is Today and H9 is your required old date and the formula will be as =DATEDIF(H9,H7,"d")
it will give number of days between the two dates.
If you required to count the present date alson use =DATEDIF(H9,H7,"d")+1

Regards
Witson

 

[MarkDave]

Hi,

You can use Datedif formula. Say H7 is Today and H9 is your required old date and the formula will be as =DATEDIF(H9,H7,"d")
it will give number of days between the two dates.
If you required to count the present date alson use =DATEDIF(H9,H7,"d")+1

Regards
Witson

Hi, that works great. My start day is e8 and end date u8 - if u8 is blank though, and in there is not yet an end date, I get an #num! Error. I need it to work out the days if u8 is blank using today as the ‘temporary’ end date until u8 is populated whenntnwill use that as the end date - does this make sense?

 

[FormR]

Hi, to get the numbers of days between two dates you just need to subtract the older one from the newer one - no need for the undocumented datedif() function.

I need it to work out the days if u8 is blank using today as the ‘temporary’ end date until u8 is populated

For this you can try:

=IF(ISNUMBER(U8),U8,TODAY())-E8

Note: you might need to format the cell containing the formula as general or number.

 

[MarkDave]

This is awesome thank you and works a treat. Just a thought, is it possible to extend this so the end date can be either u8, v8 or w8, or if all blank then today?

 

[JackDanIce]

n/a

 

[FormR]

is it possible to extend this so the end date can be either u8, v8 or w8, or if all blank then today?

Hi, will only one or none be populated?

 

[MarkDave]

Yes, only one or none.

 

[FormR]

Something like this then may work for you:

=IF(COUNT(U8:W8),MAX(U8:W8),TODAY())-E8