d <- "2016-07-02" # input month
Periods.No <- c( 2301 , 3287 ) # Input No of Periods
b <- - 6027 #Input a number
class( b) <- "Date"
Periods.Duration <- c( 10 , 7 ) # Input the duration of the Peiods
cat( "Data frame showing the result of forwarding a specified number of periods of a specified duration from " , as.character ( as.Date ( b, origin = "1970-01-01" ) ) , " : \n \n " )
df <- data.frame ( Periods.No , Periods.Duration , stringsAsFactors= FALSE)
df <- transform( df, Dates = b + Periods.No * Periods.Duration )
df[ nrow( df) + 1 , ] <- c( ( as.POSIXlt ( d) $year - as.POSIXlt ( b) $year) * 12 + as.POSIXlt ( d) $mon - as.POSIXlt ( b) $mon, round( ( as.POSIXlt ( d) - as.POSIXlt ( b) ) / ( ( as.POSIXlt ( d) $year - as.POSIXlt ( b) $year) * 12 + as.POSIXlt ( d) $mon - as.POSIXlt ( b) $mon) , digits = 2 ) , d)
df
ZCA8LSAiMjAxNi0wNy0wMiIgIyBpbnB1dCBtb250aApQZXJpb2RzLk5vIDwtIGMoMjMwMSwgMzI4NykjIElucHV0IE5vIG9mIFBlcmlvZHMKYiA8LSAtNjAyNyNJbnB1dCBhIG51bWJlcgpjbGFzcyhiKSA8LSAiRGF0ZSIKUGVyaW9kcy5EdXJhdGlvbiA8LSBjKDEwLCA3KSMgSW5wdXQgdGhlIGR1cmF0aW9uIG9mIHRoZSBQZWlvZHMKY2F0KCJEYXRhIGZyYW1lIHNob3dpbmcgdGhlIHJlc3VsdCBvZiBmb3J3YXJkaW5nICBhIHNwZWNpZmllZCBudW1iZXIgb2YgcGVyaW9kcyBvZiBhIHNwZWNpZmllZCBkdXJhdGlvbiBmcm9tICIsIGFzLmNoYXJhY3Rlcihhcy5EYXRlKGIsb3JpZ2luID0gIjE5NzAtMDEtMDEiKSksIiA6IFxuXG4iKQpkZiA8LSBkYXRhLmZyYW1lKFBlcmlvZHMuTm8sIFBlcmlvZHMuRHVyYXRpb24sIHN0cmluZ3NBc0ZhY3RvcnM9RkFMU0UpCmRmIDwtIHRyYW5zZm9ybShkZiwgRGF0ZXMgPSBiICsgUGVyaW9kcy5ObyAqIFBlcmlvZHMuRHVyYXRpb24pCmRmW25yb3coZGYpICsgMSwgXSA8LSBjKChhcy5QT1NJWGx0KGQpJHllYXIgLSBhcy5QT1NJWGx0KGIpJHllYXIpKjEyICsgYXMuUE9TSVhsdChkKSRtb24gLSBhcy5QT1NJWGx0KGIpJG1vbiwgcm91bmQoKGFzLlBPU0lYbHQoZCkgLSBhcy5QT1NJWGx0KGIpKS8oKGFzLlBPU0lYbHQoZCkkeWVhciAtIGFzLlBPU0lYbHQoYikkeWVhcikqMTIgKyBhcy5QT1NJWGx0KGQpJG1vbiAtIGFzLlBPU0lYbHQoYikkbW9uKSwgZGlnaXRzID0gMiksIGQpCmRm
stdin
RGF0ZSwgQW1vdW50LFJlbWFya3MKMjAxNi0wMS0zMSwxMjMsMDIwOCDpgY7lubQgODgrMzUKMjAxNi0wMy0yNyw5MywwMzI5IHdlZGRpbmcgU2FuZHkgTm8uIDIgJDExNQoyMDE2LTA1LTIzLDEyMCwwNTI4IHdlZGRpbmcgcmVjZXB0aW9uCjIwMTYtMDYtMjYsMTAwLCB2ZXJ5IHNob3J0IGhhaXJjdXQgCjIwMTYtMDctMzAsMTE1LFBsYW5uZWQgIFNhbmR5IE5vLiAyICQxMTUg
Date, Amount,Remarks
2016-01-31,123,0208 過年 88+35
2016-03-27,93,0329 wedding Sandy No. 2 $115
2016-05-23,120,0528 wedding reception
2016-06-26,100, very short haircut
2016-07-30,115,Planned Sandy No. 2 $115