Find the UNIX Datetime stamp for a specificdate based on the current date in VBA?

[borski88]

I would like to have the unix timestamp to be 2 Wednesdays back based on the current date. For example for Dates if I ran the file on a day within 10/25 - 10/31, the Start date would be 10/18. If I ran the File on 11/1, the start date would be 10/25. I figured it out in a formula for a cell, but I would like to use UNIX Time in VBA if possible:

<code>    =TODAY()-WEEKDAY(TODAY(),13)-6
</code>

 

[pbornemeier]

Perhaps thks:

=TEXT(NOW()-WEEKDAY(TODAY(),13)-6,"yyyymmddhhmmss")