Date to date formula

[Challebjoern]

Hey guys.

is it possible to write a formula like the topic says?

Something like this

Please Login or Register  to view this content.

To make it look like this "2017-06-07 - 2017-07-07"

I don't have any data in reference cell so far, but if it's neccessary I can put it in somewhere.

[Jonmo1]

Close, but you have to apply the TEXT function to the dates.

=TEXT(TODAY(),"yyyy-mm-dd")&" - "&TEXT(TODAY()+30,"yyyy-mm-dd")

[AlKey]

Or

Please Login or Register  to view this content.

[Challebjoern]

Thanks guys. Both solutions worked just fine! Just one small that is annoying. When I do the formula, the month part is "00" for some reason. Any idea what it could be?

Like this 2017-00-07

[Jonmo1]

You're welcome.

change mm to just m (same for the day part, dd=07,d=7)

[Challebjoern]

You're welcome.

change mm to just m (same for the day part, dd=07,d=7)

Tried to do so, it still shows the month part with just a zero "2017-0-7" or "2017-0-07"

[Jonmo1]

Really? You must have some different regional settings that use different date formats.

See if you can look through your actual cell format settings for the date formats.

[AlKey]

Try to switch yyyy-mm-dd to yyyy-dd-mm and see if it works

[Challebjoern]

Really? You must have some different regional settings that use different date formats.

See if you can look through your actual cell format settings for the date formats.

Solved it by changing it to capital letters, wierd but it worked! xD ex. YYYY-MM-DD.