Hi all,
Here is a simplified description of the data i'm dealing with:
Left hand Column (column 1): Daily dates
Right hand Column (column 3): Data manually entered on the first day of each month
Middle Column (column 2): Data in column 3 divided by 30
Issue:
Instead of having to drag down my values manually up until the first of the next month, i want to devise a formula for column 2 that uses the data of the previous first day of the month untill the next month arrives. The purpose of this is so that i can merely alter just 1 value in the cell of colum 3 to get all the corresponding changes in the cells of column 2.
i think this involves some sort of IF function, but am not sure exactly how to relate this to the date of the month.
I have attatched a sample file to clarify.
SAMPLE FILE EXCEL FORUM.xlsx
Bookmarks