Date and Time calculation help

[Mohamed Sameer Kazi]

Hi All,

just need help to extract date from date and time function and calculate the number or days for current date

trying but seems some format issue in data

need assistance

Many Thanks

 

[Belleke]

Like this?

 

[pecoflyer]

FYI formatting is the way XL shows it to the outside world. The underlying values (even date and time) are numbers.
Search the Net for more details on Excel and dates/time.
Also avoid using manual alignment, ti gives false impression as numbers are right-aligned by default and text, left. Centering deprives you from that information

 

[Mohamed Sameer Kazi]

Thanks Pecoflyer,

also i change the setting ( Time and Date to UK )

it works.