Hi
Anyone know a solution to this one?
Got a spreadsheet which calculates todays date in cell (A2)
formula =TODAY()
(The cells for months are all formatted to display as MMM)
To calculate future months (i.e. cells B2 & C2) I use the formula’s:
(B2) =DATE(YEAR(A2),MONTH(A2)+1,DAY(A2))
(C2) =DATE(YEAR(B2),MONTH(B2)+1,DAY(B2))
i.e. adding +1 to the month of the cell referenced
This works fine mostly, but when you get to the end of Jan, the + 1 month takes you beyond Feb and so displays as March (skewing the figures)
Any ideas how to adapt this to calculate months ahead as desired?
N
Anyone know a solution to this one?
Got a spreadsheet which calculates todays date in cell (A2)
formula =TODAY()
(The cells for months are all formatted to display as MMM)
To calculate future months (i.e. cells B2 & C2) I use the formula’s:
(B2) =DATE(YEAR(A2),MONTH(A2)+1,DAY(A2))
(C2) =DATE(YEAR(B2),MONTH(B2)+1,DAY(B2))
i.e. adding +1 to the month of the cell referenced
This works fine mostly, but when you get to the end of Jan, the + 1 month takes you beyond Feb and so displays as March (skewing the figures)
Any ideas how to adapt this to calculate months ahead as desired?
N