Hello,
I would like to know what formula I would use to have a cell's value increase with the start of a new month. ie cell a1 grows by $500.00 at the start of every month.
Thanks
Hello,
I would like to know what formula I would use to have a cell's value increase with the start of a new month. ie cell a1 grows by $500.00 at the start of every month.
Thanks
Assuming the date in cell A1 is:
=MONTH(DATE(2006,8,1))
and Cell B1:
=MONTH(NOW())
then cell C1 is:
=(B2-A2)*50
Since the Now function is volatile, it will update autooatically!
Best regards,
Ray
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks