Subtract 14 days from a date

[#1]

Hi,

I would like to subtract 14 days from a dates with the format 'DD.MM.YYYY hh:mm:ss[.fff]' and obtain as a result a date with the same format but 14 days earlier.

I believe this might be simple to solve but I'm struggling with this and I would appreciate if anyone could help me.

Thanks in advance!

Mariana

[disqr_rm · Accepted solution]

Try this:

=date(OriginalDate-14, 'DD.MM.YYYY hh:mm:ss.fff')

[#3]

Hi,

I already tried it and it creates random dates but these dates have nothing to do with OriginalDate -14.

Any more suggestions?

Thanks,

Mariana

[#4]

Sorry!

I was looking for the wrong field...I think I'm just too tired ...

Your suggestion works!

Thanks once again.

Mariana

[#5]

Hi, did you know how to get avegare sales of 14 days ago? It just like getting sales daily but only 14 days ago... 🙂 thanks.

[naveen409]

Hi Disqr_rm,

I am having similar question like this.

I want to See like First 7 Days of a month and 14 , 21, 28 days of a month 

Can You help me?

Thanks in advance