Please see attached example. The data i have is 3 cells: Start date, End date, and No of periods. I want the result to be equal dates spread through the given period.
Date formula.xlsx
Please see attached example. The data i have is 3 cells: Start date, End date, and No of periods. I want the result to be equal dates spread through the given period.
Date formula.xlsx
Hello,
In your example, you have the 1st of the month as the "equal" date. These are one calendar month apart. Is this the result you want every time, or would you rather it split to the nearest day etc...?
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
see the attached file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks