Last Month Reload time

[Anonymous]

Hello,

i want to show on the file the month before of the reload time.

i have the following function:  Date(ReloadTime(),'YYYYMM').

if this month the result should be 201707. i want to show 201706

[Frank_Hartmann · Accepted solution]

Date(ReloadTime()-30,'YYYYMM')

[dberkesacn]

=Date(AddMonths(Date#(201706,'YYYYMM'),-1),'YYYYMM')